Forum Discussion
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...
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)
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.