Using Index and Match Formula

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top