Thread: If with Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
danwes danwes is offline
external usenet poster
 
Posts: 1
Default If with Vlookup

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