Forum

Notifications
Clear all

Vlookup returning #N/A but not the common mistakes

3 Posts
2 Users
0 Reactions
190 Views
(@grace)
Posts: 9
Active Member
Topic starter
 

I am trying to conduct a vlookup but the values even though appear identical after cleaning, trimming, etc still will not return the required result.

thanks for any help

 
Posted : 23/05/2020 11:49 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Grace,

If you check how many characters in cell A3 on sheet 'Vlookup error' using =LEN(A3) you'll see it returns 7. So you also need to clean/trim this column of data too.

If you type '195023 (including the apostrophe) in cell A3, the VLOOKUP formula in cell B3 resolves correctly, further confirming the data on this sheet is now the issue.

Mynda

 
Posted : 23/05/2020 6:57 pm
(@grace)
Posts: 9
Active Member
Topic starter
 

Thank you so very much.....I was so frustrated.

You guys are the very best!!!!! good job!!!

 
Posted : 24/05/2020 1:38 pm
Share: