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

Fix your parentheses:
=IF(ISERROR(VLOOKUP(A2,males,6,0)),"",IF(VLOOKUP(A 2,males,6,0),"XX",""))

Does the above work for you? If not give more detail about what
errors/problems you're encountering.

Dave
--
Brevity is the soul of wit.


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

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.

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.