Forum Discussion
Vlookup formula error
The names are in column B, not in column A, so the lookup range should be B3:E22, and the column index should be 4 instead of 5:
=VLOOKUP(G4, B3:E22, 4, FALSE)
The names are in column B, not in column A, so the lookup range should be B3:E22, and the column index should be 4 instead of 5:
=VLOOKUP(G4, B3:E22, 4, FALSE)