One more question, is there a way to have the cells not display #VALUE
when A25 is blank?

Dennis

On Nov 4, 2:50 pm, "Biff" wrote:
Use a helper cell to parse the name:

A24 = George Shirley

A25 = formula:

=LEFT(A24)&". "&MID(A1,FIND(" ",A24)+1,255)

Returns: G. Shirley

Then:

.........MATCH(A25,HiddenStats!$A$20:$A$150,FALSE) ........

Or:

.........MATCH(LEFT(A24)&". "&MID(A1,FIND("
",A24)+1,255),HiddenStats!$A$20:$A$150,FALSE)..... ...

Biff

"CribbsStyle" wrote in ooglegroups.com...



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!- Hide quoted text -- Show quoted text -