I have the days of the week (Mon, Tue....) in C1:C7
I have the prices in S1:S7 starting with Monday's price
In D1 I have =INDEX($S$1:$S$7,MOD(ROW(),7)+3-(MOD(ROW(),7)+36)*6)
This is copied down the D7
I hope Fri needed Tue's price not Wed's !
If you have the days in C but not starting in C1: say in C5 then replace
ROW() by ROW()-4 in both places.
Adjust S1:S7 to fit your model
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Daniel Q." wrote in message
...
i have a complex if statement that i need help with. I have a contract
that
tells to post a price from different days then from the day the price was
published. I need a formula that will give me Thursday's price for Monday
etc.

Day Price Publication Price
Mon Thurs (3days after mon)
Tue Fri (" ")
Wed Sat(" ")
Thurs Mon
Fri Wed
Sat/Sun Wed

I have the day (ddd) in one column - can i reference back to that somehow?

day(ddd) is in column c, the price is in column w, how can i tell column s
to give me thurs price for the monday cell, etc based on the price date
parameters? Is there even a way?

thx for all your help in advance!