Forum Discussion

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

Patrick2788

Silver Contributor

Jan 28, 2020

ktwogood253

Are you an Office insider? XLOOKUP is not yet in general release (It's coming very soon.).

ktwogood253
Copper Contributor
Jan 28, 2020
Patrick2788
Oh. Well then I guess it is back to VLookup which is also not working. Anytime I try to go between two different workbooks I have this issue.
Thanks for your response.
Kari
- Patrick2788
  Silver Contributor
  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)
  - ktwogood253
    Copper Contributor
    Jan 28, 2020
    Patrick2788
    Thank you! I got it to work using the VLookup. Now to replicate 5 more times for the other location workbooks.
    Kari
- SergeiBaklan
  Diamond Contributor
  Jan 28, 2020
  ktwogood253
  
  Kari, is XLOOKUP available or not you may simply check starting to type =XLOO - function name will be prompted.
  
  Here the error is at least in reference ...[CTC_SIDEMP_CRSW_MAPPING_138.xlsx]sheet1!$B$2:$B$2:$B$20292..