Hi i am using a vlookup and getting #Na errors but for example the value is 51290 and it exists in both areas so should not get a NA error. when i make it '51290 it then finds it and works, is there a faster way in doing this so i dont get the na error?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vlookup with #na values even when value exists
t
but i have multiple values that like this that i would have to put a ' in front of them
That did not work, is the lookup value is on the left side of the cell and then the value in the table array is on the right side of the cell, but when i put a ' in front of the value in the table array the value appears
but i have multiple values that like this that i would have to put a ' in front of them
Upvote
0
Similar threads
- Question
- Question
