If date in column A matches reference date, display data 3,5 & 10 days after

So, on attached spreadsheet I have a list of dates in col A, with price in B. In col G, I have specific dates. In H,I,J,K i have specific dates that I would like to see prices also. I have highlighted what I would like end result to look like.

I would like to have the ability to enter different data in A.B & G and have it show 3,5, & 10 days after.

thank you,

Enter this into cell H3 and fill down:

=INDEX($B$2:$B$121,(MATCH($G3,$A$2:$A$121,0)))

3.xls

See attached. You can fill down as needed

Entire sheet completed

4.xls

I reread your question and realized that I think you are looking for your heading to say PRICE 3 days after, etc. If that is the case then I have attached a file that will do this.

Please note that you have several values that are guessing at the correct price because you have gaps and missing days. Let me know how else I can assist.

5.xls

Thanks Matt. Yea, thats the issue. There are gaps in the dates (holidays and weekends). I need to capture the price 3, 5 & 10 days after the date in col G. I appreciate your help, I'm working on it.

This should work for you then. You should use some sort of a value for the missing days to reference. Even if you enter in the date with a zero it would help your results to be more clear.

Problem is, If I have the dates that arnt listed and enter zero, the result would be zero. (This is a financial spreadsheet with the earnings date (Col G) and how the stock reacts 3,5 7 10 trading days after.)

Is it possible to setup so when the earnings date (Col G) matches date in A, it would take the cell value on that row for current, the Cell 3 rows above( 3 days later) the cell 5 rows above (5 days later) etc....

The issue is that we are asking excel to reference a day that does not exist in the data. We can search and return any data you would like but if the data is not there then we need to tell Excel what to do.