Dates

[edrachel]

Hi, I have a formula like this:
=VLOOKUP(B6,Inventory!A3:AB68,3,FALSE)

What this does is B6 is the item name, Inventory is the worksheet
A3:AB68,3 is where the price is found.

Now what I want to do is add a date. Say my price today would be $2.0
but effective 08/01/06 my price will increase to $2.50. If someon
orders today but does not want to make payment or get delivery befor
08/01/06, I want to charge the $2.50 not the $2.00 but because I a
working now and in the future, I want to be able to put a date in lik
today and it will pull the prices effective today, but if I put in
date of 08/15/06, then I want it to pull the price from the 08/01/0
price list. I would like to be able to put the date somewhere on th
worksheet so I would not have to mess with each formula when the price
change. Like maybe just put the date on A4. Add A4 to the formula an
get it to pull the correct prices. I hope this makes sense. I a
familar with Excel but not great. If you could write out the fomul
using A4 for the date, then a formula for the A4 to make sure it pull
the right price. Thanks for all your help

 

[Nick Hodge]

You could us an IF statement and new price sheet (NewPricesWorksheet)

=IF(A4>datevalue("07/31/06"),VLOOKUP(B6,NewPriceWorksheet!A3:AB68,3,FALSE),VLOOKUP(B6,Inventory!A3:AB68,3,FALSE))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)