VLOOKUP #N/A Error

[M.Yasir Fakhr]

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 

[#2]

@M.Yasir Fakhr 

There may be space characters in the column you are trying to match.   

If not, you might want to check the Range as well 

[#3]

@M.Yasir Fakhr 

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)