Comparing orders vs customers to find the ones who didnt order

Rosario - Sep 27, 2015 at 12:16 PM

I have a list of 500 customers on one sheet with multiple columns of data for each one, Last name is column O, first is column P.

On the second spreadsheet which tracks my companies orders, The simplest way to compare them is column D is last name and column E is first name. The variable is Column I, order type and column A order number.

I need to identify the customers who haven't placed an order with us first and then identify, separately, the folks who did by order type.

Thanks in advance!