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

1. ## 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,

2. ## Re: If date in column A matches reference date, display data 3,5 & 10 days after

Enter this into cell H3 and fill down:

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

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

3.xls

See attached. You can fill down as needed

4. ## Re: If date in column A matches reference date, display data 3,5 & 10 days after

Entire sheet completed

4.xls

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

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

6. ## Re: If date in column A matches reference date, display data 3,5 & 10 days after

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.

7. ## Re: If date in column A matches reference date, display data 3,5 & 10 days after

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.

8. ## Re: If date in column A matches reference date, display data 3,5 & 10 days after

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....

9. ## Re: If date in column A matches reference date, display data 3,5 & 10 days after

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1