Vlookup and uncapitalised/capitalised issue

[munkee]

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

Command	CST1		CST2		CST3	
Team	EU1	√	EU7	√	FR6	√
	EU3	√	EU9	√	FR7	√
	EU4	√	EU10	X	FR8	√
	RA1	√	EU11	√	FR9	√
	RA2	√	EU12	X	FR10	√
	RA3	√	EU13	√	FR11	√
	DN1	√	EU14	X

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

=IF(ISNA(VLOOKUP(F8,sectionnames,1,FALSE)),"X","√")

The range the vlookup looks within

sectionnames range:
RA3

RA2

RA1

FR9

FR8

FR7

FR6

etc..

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

RA3

RA2

RA1

fr9

FR8

FR7

FR6

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

[teylyn]

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