Jul 15 2019 10:16 PM
Dear all,
I am facing the issue in vlookup formula once I put the formula in cell some cell pick the values and some cells are not picking the value even the find the name is same...
kindly help me
Thanks
Yasir
Jul 15 2019 10:23 PM
There may be space characters in the column you are trying to match.
If not, you might want to check the Range as well
Jul 16 2019 03:26 AM
I guess the first column of the table_array argument of your VLOOKUP has leading, trailing, or extra spaces. In such a case, you may use TRIM in LOOKUP, like this:
=LOOKUP(PI(),
1/(TRIM(A:A)=D2),
B:B)