Thread: If with Vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.