finding a value with more than one criteria
Typo alert:
=INDEX(E1:E10,MATCH(1,(A1:A10=1)*(C1:C10="TR"),0))
I added the 1 in match(1,...
Peo Sjoblom wrote:
=INDEX(E1:E10,MATCH(,(A1:A10=1)*(C1:C10="TR"),0))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
wrote in message
...
Hi
I need to find a value in column E but it has to meet 2 different
criteria
the value in column A and column C must match before
so if this is wat it looks like
A B C D E
1 X TR X 3.1
2 X TR X 3.1
1 X TL X 3.1
I need to find 3.1 only when Column A is 1 and Column C is TR
Thanks in advance
--
Dave Peterson
|