Results 1 to 2 of 2

Vlookup and uncapitalised/capitalised issue

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2009
    Location
    Newcastle,England
    MS-Off Ver
    Excel 2003
    Posts
    78

    Vlookup and uncapitalised/capitalised issue

    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
    Last edited by munkee; 12-21-2009 at 08:49 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1