Forum Discussion

M.Yasir Fakhr's avatar
M.Yasir Fakhr
Copper Contributor
Jul 16, 2019

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 help me

 

Thanks

Yasir 

Formulas and Functions

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jul 16, 2019

    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)

  • Kodipady's avatar
    Kodipady
    Iron Contributor
    Jul 16, 2019

    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 

Resources