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 the help explanation and my spreadsheet trying to use these functions, and can't get them to work.  Please advise my miss usage.

 

Thanks Richard Lambhttps://1drv.ms/x/s!Avoy1y2cOvrvjcVquUtZr4812EnhLw?e=EKF4BX 

Formulas and Functions

2 Replies

  • 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)