Forum Discussion
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$20292,0,2)
I'm getting a #Names? error. Please help. As you can see these are very large worksheets.
I need to look up column A from one worksheet to return data from a different worksheet.
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)
9 Replies
XLOOKUP is still rolling out to all Insiders, so you may not see it quite yet. It will be available to everyone soon.
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.
For your problem , Vlookup is the best. Just try it
https://gyankosh.net/msexcel/practice/vlookup-examples/#gsc.tab=0
and if we talk about your formula it contains a syntax error.
Especially with your file names.
Kindly check it.
It seems like you have entered them manually. To avoid the error you should use them by opening the sheets and then selecting the ranges. It avoids the error.
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)
