VLOOKUP 3 data points

[Jacks18928jl]

Hello

Thanks in advance for any help

I am looking for a formula which looks for product ID (example 10328166154) then returns the number of stock available by size by todays date

Please find attached excel example

Thanks

REQUIRED OUTPUT
L M S S/M XL XS XXL
10328166154 31 42 69 47 37 46 0
22222224333 69 69 69 69 69 69 69

[Crooza]

try this in G3 and drag across and down

Please Login or Register  to view this content.

[Jacks18928jl]

Thanks for replying

When I add formula to H3 on example doc it returns spill and the QTY column is not highlighted. Do I also need to add TODAY formula into the worksheet?

Thanks

[wk9128]

Cell H3 formula , Drag down and across

Please Login or Register  to view this content.

[Jacks18928jl]

Nice one, thanks for that

[wk9128]

@Jacks18928jl You're Welcome. Glad to help . Thank You for the feedback.

[josephteh]

Try
G3=UNIQUE(FILTER(B3:B30,A3:A30=TODAY(),"")), copy down,
H3=LOOKUP(G3#&H2:N2,B3:B30&C3:C30,D3:D30), copy down.

[josephteh]

Sorry, no need to copy down. Formula will spill down.