Using Index and Match Formula

[Brett]

Hello,

I am having a few issues using the Index and Match formula in Excel.
For example I can get the Index and Match formula working if the data
is layed out like below:

A B
1 01/01/06 0.7
2 07/01/06 0.8
3 14/01/06 0.9

i.e. Cell A1 is 01/06/06.

Using the formula =(INDEX(A1:B3,MATCH("06/01/06",A1:A3,1)+1,1)) will
return 0.8. Which is correct I want the next row down.

How can I use this formula if the data is the other way round?

A B C
1 01/01/06 07/01/06 14/01/06
2 0.7 0.8 0.9

I want to return the amount depending on the date, for example if the
date is 06.01.06 I want to see 0.8. I tried a HLOOKUP but it returns
the left hand side i.e. 0.7. Anyone offer any help?

Thanks,
Brett

 

[muddan madhu]

try this

=INDEX(A1:C2,2,MATCH("06/01/06",A1:C1,1)+1)

 

[Brett]

try this

=INDEX(A1:C2,2,MATCH("06/01/06",A1:C1,1)+1)











- Show quoted text -

Thank you, this is perfect. You are a star.