try
=IF(ISERROR(VLOOKUP(A2,males,6,0)),"","XX")
the second vlookup would give a "" for any non positive-numeric answer from
the 6th column
"danwes" wrote:

=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.