Vlookup formula error

Copper Contributor

vlookupFormulavlookupFormulaResultResult

1 Reply

@MAAlam 

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)