Forum Discussion
Help with Data formula
I have the setup the following formual to find Hispanic Surnames in column A: =IF(RIGHT(A2,2)="ez", "Hispanic", IF(ISNUMBER(MATCH(RIGHT(A2,LEN(A2)-FIND(" ",A2)),HispanicSurnames,0)), "Hispanic", "No...
How about
=IF(OR(UPPER(RIGHT(A2,2))="EZ",ISNUMBER(MATCH(A2,HispanicSurnames,0))),"Hispanic","Non-Hispanic")