Are you trying to perform a VLOOKUP Formula but it’s not working? Even though you KNOW the formula is right AND you KNOW the data is there? The issue MAY just be that there are leading or trailing spaces that you don’t see. After all, in an Excel cell the words “Boston” and “Boston ” LOOK identical, but they’re not (go ahead and try it, we’ll wait for you to come back!)
As I stated, they are not identical, and thus the formula will not find a match and return a “#N/A” error.
Getting rid of these spaces is as simple as typing in
=TRIM(cell that contains extra spaces)
After removing the extra spaces, you may or may not see a difference; depending on where the spaces – leading spaces (before your data) or trailing spaces (after your data). Either way, this MAY be all that is needed to make your formula work.
Keep Excelling!
Do you like this post? Comment below and / or share on Facebook or Twitter!
No comments:
Post a Comment