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