Hi,
This is my formula now.
=VLOOKUP(B6,Prices!A3:AB68,3,FALSE)
What I want to do is have the above formula look at a date, say is in cell B5 and pull the price that corresponds with that date. The B6 in the formula represents the state. Let’s say the date is 08/01. My date on this invoice is 08/10. I want the prices from 08/01 to be inserted. But let’s say there is a price change 09/01 and the date of my invoice is 10/15, I want the price pulled from the 09/01 date. Putting an actual date in the formula won’t work because it will be constantly changing. I could be working ahead and using the 10/15 date in Aug. so it needs to pull the correct prices. Is there a way to do this?? If not, is this something I maybe can do in Access? Thanks.
Bookmarks