Conditional INDEX MATCH

Hi All

Trying to solve a conditional issue with the attached spreadsheet.

Basically I have 2 sheets. The first an orders sheet which shows all orders from companies with the date of the order, whether it is a repeat order, and whether it has been delivered. The second sheet a customer account sheet which shows the order history by customer. I have used the following formula =IFERROR(INDEX(Orders!$B$2:$B$23,MATCH(0,INDEX(COUNTIF($A$1:A1,Orders!$B$2:$B$23),,),)),"") to extract the companies from the orders sheet however if a company has had no previous order (i.e. a new customer) and has not recieved a delivery yet I do not want him added to the sheet.

I have tried amending my formula in different ways but always encounter problems.

Any help would be great (and leave my day almost complete!)

Thanks

Hi AlKey

This works great however as I'm learning at the moment could you explain the -1 in the following:

=IFERROR(INDEX(Orders!$A$2:$A$23,SMALL(IF(Orders!$B$2:$B$23=$A2,IF(Orders!$C$2:$C$23="Y",IF(Orders!$D$2:$D$23="Y",ROW(Orders!$A$2:$A$23)-1))),COLUMNS($A$1:B1))),"")

Is this to take out the first order in the list?

Many thanks again.