Find certain cell value

[RobJ]

Hi,

I have a matrix with on the rows dates of stock prices and on th
columns stock names.

Now I'm trying to find a certain stock price on a certain date. If
try to find the stock price of Microsoft on January 1st 2005, how woul
this be done.

I know how to lookup the stock name and the stock date (using VLOOKU
etc.) but not how to combine these lookup functions in order to receiv
only one cell value.

Tnanks in advance.

Ro

 

[Bob Phillips]

Here is a formula with 1st June as an example date. ADdjust the ranges to
suit

=INDEX(A2:M200,MATCH(--"2005-06-01",A:A,0),MATCH("Microsoft",1:1,0))

 

[JE McGimpsey]

One way:

If you have the Tools/Options/Calculation/Accept labels in formulas
checkbox checked, you can use

=Microsoft 1/1/2005

Another:

If you have your table named, say, Table, and the Date in J1 and the
company on J2, you can use

=VLOOKUP(J1,Table, MATCH(J2,OFFSET(Table,,,1,),FALSE),TRUE)