Using index matching rows with 2 criteria

[earthworm]

Hi all i have a data set like this

In cell A1 : I input the date , Sell B1 i input the Tenor and Cell C1 i input the
Column , from these i want the value to appear from table below starting from cell d10:f22 , i tried to use index function , but i m lost.

how can i input 2 conditions to select row in index to get the data

Sample file attached.

http://www.box.net/shared/k953d81p5i

 

[T. Valko]

Hi all i have a data set like this

In cell A1 : I input the date , Sell B1 i input the Tenor and Cell C1 i input the
Column , from these i want the value to appear from table below starting from cell d10:f22 , i tried to use index function , but i m lost.

how can i input 2 conditions to select row in index to get the data

Sample file attached.

http://www.box.net/shared/k953d81p5i

I have your file in front of me.

The formula you have in cell G3 seems to be returning the correct result.

So, what are you having trouble with?

 

[earthworm]

I have your file in front of me.

The formula you have in cell G3 seems to be returning the correct result.

So, what are you having trouble with?

i dont have any formula in sheet . i need result in yellow highlighted cell.

 

[T. Valko]

i dont have any formula in sheet . i need result in yellow highlighted cell.

Maybe you posted the wrong file.

Cell G3 contains this formula:

=INDEX($G$12:$I$24,MATCH(B3&"-"&E3,$D$12:$D$24,0),MATCH(F3,$G$11:$I$11,0))

And it returns 72 which is the correct result from your table.

 

[earthworm]

Maybe you posted the wrong file.

Cell G3 contains this formula:

=INDEX($G$12:$I$24,MATCH(B3&"-"&E3,$D$12:$D$24,0),MATCH(F3,$G$11:$I$11,0))

And it returns 72 which is the correct result from your table.

please recheck the file is correct

http://www.box.net/shared/k953d81p5i

 

[T. Valko]

please recheck the file is correct

http://www.box.net/shared/k953d81p5i

This screencap shows the formula that's entered in cell G3.