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)


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


Thank you very much