Forum Discussion

ktwogood253's avatar
ktwogood253
Copper Contributor
Jan 28, 2020
Solved

Help with Xlookup

I am attempting to use the new XLookup instead of VLookup. I have formula as: =xlookup(A17,[CTC_SIDEMP_CRSW_MAPPING_138.xlsx]sheet1!$A$2:$A$20292,[CTC_SIDEMP_CRSW_MAPPING_138.xlsx]sheet1!$B$2:$B$2:$B...
excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Jan 28, 2020

    ktwogood253 

    I think it's likely you don't have XLOOKUP yet. 

     

    Try this for VLOOKUP:

     

    =VLOOKUP(A17,[CTC_SIDEMP_CRSW_MAPPING_138.xlsx]sheet1!$A$2:$B$20292,2,0)

     

     

Lewis-H's avatar
Lewis-H
Iron Contributor
Apr 03, 2020

XLOOKUP is still rolling out to all Insiders, so you may not see it quite yet. It will be available to everyone soon.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 03, 2020

    Lewis-H 

    If XLOOKUP is not available for some insider I'd recommend to send a frown since that's a bug. It has to be. At least on Windows Desktop.

Resources