Match 3 criteria and return multiple values

I have a sheet with 10 values

Entered - Entered at - Promo - Type -Date -Amount - Member Name - Member Number - Staff - Notes

i then have 8 sheets with the different values of promo

i want to match the cells for promo and type exactally, and anything within a calender month, and return the values of date, entered, amount, member name, member number, staff and notes.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Hope this helps.

Pete

hopefully this works

Originally Posted by Glenn Kennedy

??? What do you want to see and where do you want to see it? A blank template and no explanation isn't much to go on...

Id like all the fields in partsdata to go into cashwheel 2019. Based on type and promo fields, and date

Here it is again.

Ive created 2 lines in partsdata.

One line should then be found by the january column of the bingo sheet,
while the other line should be found by the january column if the cashwheel sheet.

Thank you, ive just gotten back in to the office and this is almost perfect.

Of course as soon as i get back they want something different.

They want a new sheet called reports, as well as a problem with the first page, do you know how i can set it so it doesnt make me put something in notes?

Sorry,

all values are in parts data.

reports should have items of that promo type, and date only.

i used the one you gave me before and was trying to edit it. how ever i got stuck on the month part, and was not able to change it to the specific date.

in c7 there is a drop down box, i need the

=IFERROR(INDEX(PartsData!G:G,AGGREGATE(15,6,ROW(PartsData!$H$2:$H$100)/((PartsData!$C$2:$C$100="Cashwheel")*(PartsData!$E$2:$E$100=$D$5)),ROWS(D$9:D9))),"")

bolded underlined part to read that cell