Forum Discussion

TMAZZ's avatar
TMAZZ
Copper Contributor
Mar 24, 2019

Vlookup returning N/A except for three cells

I have the first two columns setup as table 3, 

 

I'm doing a simple vlookup and the formula is only returning three cells with details, doesn't make sense the formatting is all the same. What is going wrong?

 

 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    TMAZZ , most probably that means you have no exact match of your values. Try to compare the manually if text is identical, e.g. test =H14=B37