Look in a table

[Guest]

I want to look for a data in a table.

Find the data which is in row 3 if the data of row 1 and 2 are matching my values.

I have
A ; H ; K
B ; J ; K
B ; K ; L

If row1=B and row2=J then I want the data in row3.

Thanks for your help.

 

[Aladin Akyurek]

On 2002-03-06 13:57, Anonymous wrote:
I want to look for a data in a table.

Find the data which is in row 3 if the data of row 1 and 2 are matching my values.

I have
A ; H ; K
B ; J ; K
B ; K ; L

If row1=B and row2=J then I want the data in row3.

Thanks for your help.

Lets say that A2:C4 houses the sample you provided.

In E1 enter: B [ a condition ]

In E2 enter: J [ likewise a condition ]

In E3 enter:

=INDEX(C2:C4,SUMPRODUCT(MATCH(E1&"@"&E2,A2:A4&"@"&B2:B4,0)))

Caveat. The formula expects that there are identical rows of values (duplicates) in the range of interest.

 

[Guest]

It works great !
Thanks a lot.