Originally Posted by Eleni

Hi all,

I have attached a sample excel summarizing my data.
I have a series of equity names, for which vertically i have their prices and corresponding dates.

What I want to do, is in a seperate location, by specifying only the equity name and the date to get the correct price.

So far I have reached to this formula:
=INDEX($A$1:$H$15,2+MATCH(J7,$A$3:$A$15),MATCH(J6, $A$1:$H$1,0)+1).

Its incomplete however, as it only looks at the first column for the date, and ignores the relevant column ie the one under the equity name. I think I need to use vlookup and offset.

Can somebody help me pls?