Extract multiples records from adatabase which meet a specific condition

[Danny77]

I need a formula in order to extract from a database (located in an worksheet) multiple records (in a different sheet) which meet a specific condition.
Practically in the file attached: I need a formula to extrcat from first sheet all the items which are available in a specific month.

Best regards!
ciprian

[benishiryo]

hi ciprian. great that you can finally post. try this array formula in D6:

=IFERROR(INDEX('Table of Items'!$B$4:$B$44,SMALL(IF('Table of Items'!$C$4:$C$44=$E$3,ROW('Table of Items'!$B$4:$B$44)-ROW('Table of Items'!$B$4)+1),ROWS(D$6:D6))),"")

you have to paste the formula inside the formula bar & press CTRL + SHIFT + ENTER. When done correctly, you should see curly brackets surrounding it. drag the formula down as much as you need. but do note that your texts in your validation list must be the same as the texts in "Table of Items" column C. currently, it seems that your months in the validation list have an extra space behind.

hope you love this forum as much as i do.
=)

[Danny77]

ThanksBenishiryo, but doesnt work (in Target sheet, the result is "True") ...