Easy problem for yall. But not me.

[lahtidah1228]

Group,

I have a data base that I am trying to use VLOOKUP and find the QTY for SO-ABCD for the 5PM 7PM and so on but I am not figuring out how to do, can you all excel gods help me?

 

[braindiesel]

How about something like this...

Book1
	A	B	C	D
1	SO#	Time	QTY
2	SO-ABCD	19	150
3
4	SKU	SO#	TIME	QTY
5	123456	SO-ABCD	9/28/2020 15:00	100
6	123456	SO-ABCD	9/29/2020 17:00	125
7	123456	SO-ABCD	9/30/2020 19:00	150
8	456789	SO-EFGH	9/28/2020 15:00	200
9	456789	SO-EFGH	9/29/2020 17:00	225
10	456789	SO-EFGH	9/30/2020 19:00	250
Sheet1

Cell Formulas
Range	Formula
C2	C2	=SUMPRODUCT((D5:D10)*(B5:B10=A2)*(HOUR(C5:C10)=B2))

 

[lahtidah1228]

Brian,

Surely it is not that easy is it. Lol. Im going to try it in a bit and see. Thank you very much.

 

[braindiesel]

Brian,

Surely it is not that easy is it. Lol. Im going to try it in a bit and see. Thank you very much.

Hope it works... let me know