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!
|