Apr 23 2019 06:38 AM
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 will show the number in a4.
The argument is, =vlookup(d2,a2:b170,2)
It doesn't get more basic than that but it is not working correctly. I'm using Office 365.
What could possible be wrong?
Apr 23 2019 07:18 AM
@williep , if in D2 the name which is in A5, the formula shall return you the value from B5, isn't it?
Apr 23 2019 10:49 AM
Apr 23 2019 11:09 AM
@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.
Apr 23 2019 02:17 PM