Index, small, if, row llok up multiple values and return a result

Hello,

I have a question regarding excel formulas usinf the Index, Small, If and row functions together to return a result. I am not to clever with excel and managaed to put the following Formula together as an array formula.

=IFERROR(INDEX('Sold New Cars'!$D$2:$D$350,SMALL(IF(Commission!$B$6='Sold New Cars'!$A$2:$A$350,ROW('Sold New Cars'!$A$2:$A$350)-ROW('Sold New Cars'!$A$2)+1),ROW(1:1))),"")

I have attached below the spreadsheet for you to view.

EXCEL HELP.xlsx

Basically the above formula searches for the date on the Sold New Cars tab and returns the customers name based on the month entered into B6 on the Commission tab.

I would like to expand this formula as I have two executives located on the commision tab B14

I would like to include this in the above formula so it seraches for the month and sales executive and only returns these results.

Any help will be greatly appreciated

Thank you for your help regarding this. It has got the formula working properly, however now the results will not start in the first row as required they start on the 5th or 6th row depending on data selected.

Is there an easy fix to this?

Many thanks