If with Vlookup
What's in column 6 of the "males" range?
Do you have the name in *both* the first and the sixth column of the range?
If the name you're looking for is entered in A2, and it's in the first
column of the "males" range,
try this:
=IF(ISNA(VLOOKUP(A2,males,1,0)),"","XX")
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"danwes" wrote in message
...
=IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF((VLOOKUP( A2,males,6,0)),"XX","")).
I'm trying to use above to identify if A2 is on list names males by XX in
results column.
|