How to lookup two items and return the results attached to the those two values

Hello I am having trouble taking two values from a list of data and having them populate another list. It will probably be easier to understand with the example below.

A1:Month B1:Customer C1: number of items D1:time
A2: AUG B2:Customer 1 C2:5 D2:5:00
A3: AUG B3:Customer 1 C3:6 D3:7:00
A4: OCT B4:Customer 2 C4:7 D4:6:00

This is a similar table to the data i want to use. I want to look up both the "Month" and "Customer" and return all the results for the customer that month. If I enter "AUG" into a cell and "Customer 1" into a cell it should return "2" results for "customer 1" from C2:D3( the number of items and time categories) I have tried using vlookup but it is only good for looking up the the top result of "Customer 1" rather than displaying both. I think some combination of index and match might work but I can't seem to find one that works how I'd like. Any help would be appreciated. I am new to this forum so I am not sure if I am posting this correctly.

Thank you for the replies, I was actually hoping to do something else with the data though. I want to have a user type in the Month and then type in the customer name and then the results to the right of the customer should display in a table below. For example if the customer typed in Aug and customer 1 then the table would return both the results for customer 1 (example below)

Enter Month: AUG
Enter Customer: Customer 1


Number of items Time
5 6:00
6 7:00


I used INDEX($C$2:$D$4, SMALL(IF($B$7=$B$2:$B$4,IF($B$8=$A$2:$A$4,ROW($B$2:$B$4)-ROW(INDEX($B$2:$B$4,1,1))+1)),ROW(B1)),COLUMN(B1))

It works sometimes but when I try to reproduce it I get errors. I don't fully understand whats going on with the formula and just guessed on the row and column placements
Thanks and sorry for the confusion in my original question

Originally Posted by Tony Valko

Try this...

Data in the range A2:D4

F2 = user entered/selected month
G2 = user entered/selected customer

Enter this array formula** in H2:

=IFERROR(INDEX(C:C,SMALL(IF($A$2:$A$4=$F$2,IF($B$2:$B$4=$G$2,ROW(B$2:B$4))),ROWS(H$2:H2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to I2.

Format I2 in whatever format 5:00 represents. Is that h:mm?

Select H2:I2 and copy down until you get blanks.

Thanks a lot! That's exactly what I needed and it is a much simplier formula than the one I was trying to work with. I was able to document my entire list no problems. Oh and for the confusion with time, I was just simply reporting the time an order was processed and yes it is in h:mm format. Thanks again.