Hello again friends,
Attached is a file where I'm getting nothing but N/A's on the VLookup return I'm not quite sure why. I think it may somehow have to do with the numbering format? From what I understand I believe my formula is sound.
Basically column D should populate the description in column C if there's a match anywhere between columns A and B. Where am I going wrong?
Remove the TRIM function and you should be all set. The issue is that TRIM will turn a number into text.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Dang, you're right. I had no idea the TRIM function turned numbers in to text! I learned that TRIM function here yesterday. Thank you Melvosh! I will mark this thread as solved.
You're welcome, happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks