Forum Discussion
VLOOKUP #N/A Error
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 hel...
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)