Forum Discussion
Vlookup errors
Thank you, Branka!
So incredibly kind for you to create an example for me.
I created your example in order to follow your formula and STILL receive the N/A error!
Could it be that my table array is too large (B3:B6431)?
Here is my view:
I have tried the formula with both semi-colons and commas between each function.
Excel is trying to tell me the error could be here:
Or within the table array?
When I replicated your example, it worked because my table array wasn't so large. I was only looking up info from $A$2:$B$9
Thank you for your advice!
It looks like there is a space before the phone numbers in column A, but not in column E. Try
=VLOOKUP(" "&E3, $A$3:$B$6431, 2, FALSE)
or if that does not work
=VLOOKUP("*"&E3, $A$3:$B$6431, 2, FALSE)
Thank you for your response and attempt at trying to help me!
I did respond below to Branka. If you are unable to see my comment, please let me know.
Could you attach a sample workbook to a private message to me? Click on my user picture.
I got it to work! It was the formating in the phone numbers that were different. I re-typed the number I was trying to cross-reference against and then it auto populated all the way down. It worked! I am still getting some N/As. See what was sent for feedback or resolution of N/A.
Here are the stats I was able to discern once I got the formulas to work. Let's see if you get the same!
I am having an issue with my responses not posting. It could be the subject matter.