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)

Forum Discussion

MAAlam

Copper Contributor

Sep 12, 2021

Vlookup formula error

vlookupFormulaResult

Formulas and Functions

1 Reply

HansVogelaar
MVP
Sep 12, 2021
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)