How to lookup values

[Sean Cunningham]

Hi

I have column A populated with Stock Market trading dates in ascending
order. Dates ignore weekends and holidays.
eg
Col A
3/1/06
3/2/06
3/7/06
3/8/06
3/9/06
3/10/06
3/13/06
3/14/06

In column B2 I put in the date I entered the market. Beside that in C2 I
have the number of days I stayed in the market


B2 C2
3/2/06 3

I am trying to populate D2 E2 F2 with the dates I was in the market
ie D2 should show 3/7/06 (First full day)
E2 should show 3/8/06 (Second day in market)
F2 should show 3/9/06 (Third and final day)

I'm guessing in D2 I would reference the B2 cell and find its match in
Column A then return the date below it. Cell E2 would reference the second
cell below and so on. However I've not been able to make this happen.
Any help would be gratefully received, thank you all

Sean

 

[Guest]

Put this formula in cell D2 and copy it across to as many cells as the number
in C2.
=$B$2+COLUMN(D)-3

 

[Ardus Petus]

Here is a solution:
http://cjoint.com/?denoPSKiRU
I added a staging "Index" column to simplify the formulas. You can hide it.

HTH

 

[Ardus Petus]

Here is a solution:
http://cjoint.com/?denoPSKiRU
I added a staging "Index" column to simplify the formulas. You can hide it.

HTH

 

[Sean Cunningham]

On Fri, 3 Mar 2006 21:41:59 +0000, Sean Cunningham wrote:

It's OK I got it sorted.

Sean

 

[Ardus Petus]

Thanks for the Feedback

 

[Sean Cunningham]

Thanks for the Feedback

Thank you all for your help
Ardus, your solution is much more elegant than my own, I am very grateful
you took the time to outline it.

Best regards

Sean Cunningham