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)

     

     

ktwogood253's avatar
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's avatar
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)

 

 

Resources