Quote:
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?
|
---------------------
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.