If with Vlookup
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.
|