if val in col3 is one of 13 codes (list), apply factor to val in c

P

PBcorn

Need a function to apply a factor to certain values (col2) in a large table
if val in same row, col3 is one of 13 codes - a list in col6. For
illustration (caps letters denote excel column labels):

A B C D E F G H I J K L M

23 a b
14 c g
42 d e
31 b
64 f
23 g
99 g

so for this example, the function would be inserted in a new column, say L.
It looks for instances of b,e and g in col B and if found returns the
corresponding value in Col A* a factor.

Suggestions appreciated. Or(Exact) doesn't work.
Thanks
 
D

Dave

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top