Lookup

[Guest]

I have a spreadsheet full of data (14 columns with column titles and 122 rows with each row representing a date - in other words across row 1 is a column title and down column A is a series of dates). Can someone tell me the best way to do a lookup of a value at the intersection of a particular row and column? For example, the number 5.01 appears in cell E11 in my spreadsheet. I want to create a function that looks up that number by looking for the date in cell A11 and the title in cell E1 to return the value (5.01 in this case) in cell E11. I am sure that it is a choose, match, vlookup, hlookup or index function but I am not sure which one or how to set it up. Any suggestions would be much appreciated. Thanks.

 

[Frank Kabel]

Hi
try something like
=INDEX(A1:N122,MATCH(date_value,A1:A122,0),MATCH(number_value,A1:N1,0))

 

[Guest]

Frank

Thanks for the help with this. That worked perfectly

Regards
Jaso
New York, NY