VlookUP words in Capital letters

[andreyx108]

Hi,

I hope someone can help me:

I need to vlook up rows, where content is only in capital letters. Can anyone advise me how to do it?


Thanks a lot!!!

 

[JackDanIce]

Welcome to the board.

Why doesn't "usual" VLOOKUP function work for you? Can you post an example of your data or where the issue is?

 

[Comfy]

http://support.microsoft.com/kb/214264