finding a value with more than one criteria
 

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

finding a value with more than one criteria
 

=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

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

finding a value with more than one criteria
 

On Oct 9, 9:34*pm, Dave Peterson wrote:
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- Hide quoted text -

- Show quoted text -

Thanks for the Help Peo and Dave... the formula worked perfectly...

Thanks again