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
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