Excel Vlookup

[@subhasishpanda4337]

Trim function worked for me. Thanks a lot for saving my time. This video deserves a BIG thumbs up.

[@chuyingwu1645]

Thank you so much for the tips! I was stuck on one of my project for two days. You are a lifesaver!

[@tbjr1127]

Trim saved me big time! Thank you so much for sharing this!

[@pindrusha]

Thank you so much! the second example was the exact same problem I've been having. I added the value function in and it works great.

[@Thescintest01]

Trim worked greatly for me, thank you for the initiatives.

[@terrybashore3490]

Thank you SO MUCH! I spent many hours trying to figure this out and you helped me in minutes!

[@10mins]

Glad I could help!

[@Randomusername106]

Exactly what I was looking for, thank you.

[@kayodeogundiya7194]

Thanks this is life saving .... Trim works for me

[@soranhusain2958]

I tried value solution and worked many thanks for sharing this video.

[@10mins]

I'm glad to hear that it helped you.

[@dyandailisan]

Thank you so much! 🥰

[@nahidulislam9452]

Thanks so much. You saved my day. God give you more knowledge :)

[@cpzg8972]

Excellente fixes!

[@ngonimichaelmayeresera749]

So useful thank you so much

[@Coleman_Covers]

Much appreciated 🙏🏼

[@katrinemaesalvador8004]

Super helpful!!!! 😊

[@blalajah]

Thank you!!

[@mostafaelsayed2925]

Thank you

[@sengottu]

Damn! I was very angry until I watched your example 3! TRIMMMMMMMMM....which is what I needed to fix this issue in my workbook.

[@bradleylapalomento8679]

actual fix starts at 2:05 FYI

[@lifeisgoodlg]

thanks Dear

[@donieoliqs2739]

Hi I have an issue with that N/A keeps on showing even after watching your video. Can I send you the file and try to sort out what is wrong with this? Thanks

[@10mins]

Yes, you can email me at [e-mail].

[@10mins]

Sorry to take so long getting back to you. I've had a lot of distractions. I'm afraid I've been unable to access the email address I gave you. If you'd still like me to take a look at your issue, try this address instead: [e-mail]

[@elmerdemetriogasmin2396]

Thanks

[@Cole-bt7de]

Sound like JimBrowning

[@10mins]

I don't know who Jim Browning is but I'm going to take it as a compliment. :)

[@neely1442]

Thx 🙏

[@nothing-oj1sz]

These NA's are so damn bogus. I cannot fix my VLOOKUP error at all.

[@10mins]

I'm sorry that the solutions I've given in this video don't fix your issue. You've obviously stumbled upon yet another way of triggering the problem. Given the number of people that encounter the N/A issue, you'd think MS would take a look at the it and offer a better approach, but I guess that's hoping for too much.

[@bahris37]

thanks