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