Forum Discussion
Vlookup Problem
I am trying to use =vlookup to show phone numbers in an excel spread sheet that has the names in column a and the numbers in column b. It couldn't be more simple. If I type the name in cell a5, it w...
williep , if in D2 the name which is in A5, the formula shall return you the value from B5, isn't it?
That's correct. I wrote a4 by mistake. It should be b4 . So when I type in a name from a5 it is returning a number from b4. Something is not working correctly. Also, some cells work ok. but the ones that don't will always return a number from the cell right above the correct cell.
I can't believe that I am the only one who has had this problem.
I can't believe that I am the only one who has had this problem.
williep , since you skip last parameter, VLOOKUP uses approximate search by default. And approximate search requires what your first column is to be sorted A to Z. Perhaps that's the reason.
- Your right. I didn't put False at the end because I was hoping that just putting a last name would be enough for it to approximate the corresponding number in the cell in the b column next to it. It works sometimes. If I put false at the end of the argument, I have to write exactly what's in the a column cell but it works every time. It's just not forgiving enough to be user friendly.