Forum Discussion
Help with Xlookup
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)
Are you an Office insider? XLOOKUP is not yet in general release (It's coming very soon.).
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
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)
Thank you! I got it to work using the VLookup. Now to replicate 5 more times for the other location workbooks.
Kari
You're welcome.
BTW this where they'll announce when XLOOKUP is released:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/ba-p/811376
It should be soon.
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..
