I have a large file with numerous VLOOKUP functions that I would like to change to INDEX/MATCH for efficiency. To do so, the INDEX/MATCH equation apparently must ignore blank rows in the data. Can this be done?
Here is my initial attempt which only works on the first item (row 4 (HRL))...