SOLVED

VLookup function

Copper Contributor

Hello- I am having trouble using a vlookup function for an excel project. I want to find the region name from a different worksheet corresponding to the country name. I have not been successful at this as it has worked on other workbooks:

 

Screenshot (14).pngScreenshot (15).png

 

Any help would be much appreciated.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@CBramlage130 

Check for extra spaces at the begin or the end of the text. Or check with LEN().

 

Thank you very much