Vlookup and uncapitalised/capitalised issue

I use the following vlookup to show whether a team name is within a set range:

Please Login or Register  to view this content.

The code to produce the above (where f8 = cell value to lookup in my sheet f8 = EU1 )

Please Login or Register  to view this content.

The range the vlookup looks within

Please Login or Register  to view this content.

This works fine unless someone adds a team name uncapitalised as FR9 below:

Please Login or Register  to view this content.

How can i get around this problem? Can i make the vlookup look for uncapitalised versions of the team name? or create a macro that capitalises all values within a column?

Thanks for any help

Hi munkee,

can you please post a data sample? Excel is notoriously carefree with upper and lower case and VLOOKUP does not distinguish between case at all. Therefore, there must be some other issue in the data....

cheers