IF + VLOOKUP return result within date range

[StaceyVECL]

Hi All,

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Date

Sku

Code

Qty

Po

Order#

Name

Ship Date

Tracking

Courier

Inv#

Cost

Shipping

Vat

Total Inc. Vat

Status

=IF(OR($B4="",$D4=""),"",IF(B4="","",(VLOOKUP(@$B$4:$B$500,Formulas!$A$1:$F$26,4,FALSE)))*D4)

I am using the above formula in column L and M to pull in a cost price for an item so that we know what to invoice. However, there is a new step. Cost price will change dependent on the date of the order for sales. Is there a way to use the formula as is but add in a step to use the date in Column A depending on the date on the formulas tab in F2 and F3 as per the below?

1	A	B	C	D	E	F	G
2	1/1/24	1/1/24	26/11/24	26/11/24
3	25/11/24	25/11/24	2/12/24	2/12/24
4	SKU	Description	Code	Cost	Shipping	Cost price sale	Shipping Sale

Thanks
Stacey

 

[Anthony47]

Could you attach a sample of the data that are in sheet "Formulas"? An image with few lines would be sufficient

 

[StaceyVECL]

Could you attach a sample of the data that are in sheet "Formulas"? An image with few lines would be sufficient

Hi Anthony,

I currently have it like this:

Wilko Code	Always Costs	Shipping	RRP	BF SOA		Dec SOA		Jan Sale
			26-Nov	26-Nov	04-Dec	04-Dec	26-Dec	26-Dec
SKU	Product Name		03-Dec	03-Dec	24-Dec	24-Dec	14-Jan	14-Jan
TWC400S-MLWK	Toucan Wireless Outdoor Camera S4	0687874	£58.30	£4.85	£99.99	£38.30	£4.85	£43.30	£4.85	£52.00	£4.85
TVD300V-ML-WK	Toucan Wireless Video Doorbell V3 with included Chime	0687875	£58.30	£4.85	£99.99	£43.30	£4.85	£48.30	£4.85	£52.00	£4.85

 

[Joe4]

Duplicate to: IF and VLOOKUP with Dates values

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.