Thank you so much for teaching how to check cell references are a match. I spent a whole day trying to figure out why my vlookup was not working until I watched your video. And as soon I applied your check method I knew where the error was - a space that I couldn’t spot!! Thank you.
This was great! Another tip - if you are getting some text values in a column correct and then suddenly interrupted by #N/A and then again further values are again correct and you are 100% sure that the value in the look up table exists and has a correct format, just sort the look up column values from A-Z.
I have used vlookup and has worked beautifully, until today doing another project and IT'S not working. It's so weird and absurd the mess. I have a list of cities and counties. Example: Cerritos belongs to LA, column A is Cerritos, column B is Los Angeles the list has 500 cities and counties they belong to and i named the sheet as CitiesCounties, and I have another sheet where I pLace the vlookup example: =xvlookup(L1,CitiesCounties!A2:B500,2,FALSE). So the T1 is where there are the cities, and on the column S I put the formula. So it works partially. It's so weird where there is city Anaheim, it put Orange, but then there are other rows that has Anaheim and the vlookup shows the #N/A. It puzzles me. I even trim/clean the whole column is case there are some stuff there. I don't know why it's not working. I don't what's wrong. If I use the xlookup(new version) would I still have problem?
This video didn't help my specific problem but the solution to the problem I had was that my table array's left most column wasn't the same as my reference value. Hope this helps someone
I have been struggling with this issue for the past three hours, thank you for this video!
Thank you so much for teaching how to check cell references are a match. I spent a whole day trying to figure out why my vlookup was not working until I watched your video. And as soon I applied your check method I knew where the error was - a space that I couldn’t spot!!
Thank you.
The Date > Text to Columns > Text did the trick! Thanks!
Thanks! Was the formatting issue that was causing me trouble. Appreciate the help
Glad it helped
This was great!
Another tip - if you are getting some text values in a column correct and then suddenly interrupted by #N/A and then again further values are again correct and you are 100% sure that the value in the look up table exists and has a correct format, just sort the look up column values from A-Z.
Awesome for the Last point, you solved my pain point
You fixed it for me! The second value beginning with an A was the only one giving an error
BRILLIANT! Thanks a lot. I knew it was cell formatting, but didn't know how to fix it. Sigh of relief.. Thanks again.
Great to hear!
I have a this problem BUT these solutions (and ALL other solutions I have found) does not fix it...... can i send u the test xls?
Solution at 4:00 really helped me. Thank you very much!
Thank you so much for this! Was stuck and couldn’t for the life of me figure out why lol
Awesome!!! This helped me so much, a got back an hour of my time🙂
Glad it helped!
Thank you - your video helped to solve the problem.
Have extra what in third product example?
Thanks, very helpful. Text columns solved my issue.
Thanks a lot, this solved my headache!!
Wonderful ❤
Did the job brilliantly.
Thanks
Most welcome 😊
I have used vlookup and has worked beautifully, until today doing another project and IT'S not working. It's so weird and absurd the mess. I have a list of cities and counties. Example: Cerritos belongs to LA, column A is Cerritos, column B is Los Angeles the list has 500 cities and counties they belong to and i named the sheet as CitiesCounties, and I have another sheet where I pLace the vlookup example: =xvlookup(L1,CitiesCounties!A2:B500,2,FALSE). So the T1 is where there are the cities, and on the column S I put the formula. So it works partially. It's so weird where there is city Anaheim, it put Orange, but then there are other rows that has Anaheim and the vlookup shows the #N/A. It puzzles me. I even trim/clean the whole column is case there are some stuff there. I don't know why it's not working. I don't what's wrong. If I use the xlookup(new version) would I still have problem?
You are amazing! Thank you!
Just liked and subscribed! I have been stuck on this for countless hours!
This video didn't help my specific problem but the solution to the problem I had was that my table array's left most column wasn't the same as my reference value. Hope this helps someone
Thank you so much!!! Soved my issue, Such an annoying excel quirk
Thank you, thank you, thank you!!!
thanks a lot sir, that helped me a lot.
Thank you you solved my problem
Thanks sir
Works perfectly
Very useful. Thanks.
You're welcome!
Very helpful!
THANK YOUUUU.
Video didn't help in my case but one of the comments did. Lookup table should have alphabetical order.
Thank You!!!
Legend