Thread: Compare
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CribbsStyle CribbsStyle is offline
external usenet poster
 
Posts: 25
Default Compare

Ok This is the setup.....

A24
--------------------------------------------------------
George Shirley

Range
--------------------------------------------------------
HiddenStats!A20:A150

Format of Names in Range
--------------------------------------------------------
G. Shirley

Code
--------------------------------------------------------
=INDEX(HiddenStats!$A$20:$N$150,MATCH(A24,HiddenSt ats!$A$20:$A$150,FALSE),7)


I need it to recognise "G.Shirley" as George Shirley, is there a way?
Any help would be appreciated!