Can you help with this issue. I am trying to learn how to do this as I have a work project covering the same concepts (vlookup, countif, and scenario summaries). It is case 1. Attached is the excel file. the directions. I have a huge project that I am working on currently that is due tomorrow.