Arrays

  • Thread starter Thread starter Jan
  • Start date Start date
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
 
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
 
Back
Top