Help with advanced vlookup and offset (in an index function)
 

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?

---------------------
Dear Eleni, Good Afternoon.

Do this:

J3 -- Equity 2 (or other TITLE)
J5 -- 12/31/2009 (or other DATE)

K3 -- FORMULA -- =VLOOKUP(J5,$A$3:$H$19,MATCH(J3,$A$1:$H$1,0)+1,0)


Tell me if it worked for you.