I am confused as to why my Excel 2016 is pulling the wrong data. I think I have the formula set up correctly. IF(G4="2A",VLOOKUP(H4,C17:K30,9),IF(G4="3A",VLOOKUP(H4,M17:U30,9)))
FYI - I have noticed other spreadsheets where I have a Vlookup in the cell is failing. It forces me to type in the...