Arrays

J

Jan

Hi,

does anybody know a solution how to assign a variable in column c a
value dependent on column a containing criteria specified in column b?


E.g., the columns contain:

a : ab,ac,ab,aa,ad,ab,aa,ac,
b: ab, ac,
c: 1,2,1,0,0,0,1,0,2,

So the function should go through column a, compare it with b and
assign values for different matches in column c.
Ideally, the function should allow for more than 7 alternatives (so the
IF function can probably not be used).

I would greatly appreciate any ideas !

Thanks

Jan
 
B

Bernard V Liengme

Hi Jan
Assuming you have an extra 0 in the example, this works for me in C1 enter
=MATCH(A1,$B$1:$B$2,0)
Copy down to C8
Best wishes
Bernard
 

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