Thread: if val in col3 is one of 13 codes (list), apply factor to val in c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default if val in col3 is one of 13 codes (list), apply factor to val in c
Hi,
If your codes are listed in Column 6 (Say, F1:F13), then in C2 enter:
=IF(COUNTIF(F1:F13,C2)0,"factor","no factor")

Is this what you need?

Regards - Dave.
Reply With QuoteReply With Quote