Forum Discussion

Richard_Lambralamb130's avatar
Richard_Lambralamb130
Copper Contributor
Nov 04, 2022

Getting VLOOKUP or XLOOKUP to function as the Microsoft 365 describes in Help Document feature.

I have copied the help example from Microsoft 365 help service and pasted it in my excel spreadsheet with the VLOOKUP and XLOOKUP formulas inserted into my spreadsheet attached as a shared file with ...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Nov 04, 2022

Richard_Lambralamb130 

The formula in L2229 is

 

=VLOOKUP(K2231,C5:C2315,D5:D2315)

 

  • This is incorrect syntax for VLOOKUP. It should be of the form =VLOOKUP(value, range, column, FALSE)
  • The value WLK is in K2229, not in K2231.
  • So you should use:

=VLOOKUP(K2229, C5:D2315, 2, FALSE)

 

The formula in L2232 is

 

=XLOOKUP(K2, C5:C2315,D5,D315)

 

  • The lookup value  is in K2229, not in K2.
  • D5,D315 makes no sense, it should be D5:D2315.
  • So you should use

=XLOOKUP(K2229, C5:C2315, D5:D2315)