Match with two variable
Posted by marc on September 08, 2000 4:04 AM
Hi i've got a (small?) problem wich i can't solve
Using =index and =match.
I would like to us this in combination with TWO matches.
One match has to be a date the second match has to be a string
The next two formulas i would like to use as ONE, where the result will be given when
=INDEX(data;=match($A3;date;0);3)
=INDEX(data;=match($A4;func;0);3)
Date funt nr
1-1-01 FZ 10
1-2-01 CL 11
Something like this
=INDEX (data;
=match($A3;date;0)
=match($A4;func;0)
;3)
When:
A3 = 1-1-01 AND A4 =FZ than result =10
A3 = 1-2-01 AND A4 =FZ than result #n/a
A3 = 1-2-01 AND A4 =CL than result 11
etc. etc.
W