Hi All,

I have a workbook with 14 sheets showing customer numbers then the make of
car purchased then whether the vehicle was new or used. Eg:

Customer number 12345 then make "FO" then new "N" as follows
12345 FO N
Each workbook also shows the above info in there own columns as well.

I have another sheet showing the same data, but the data is from a different
date range showing the same sort of info as the 14 other sheets. The customer
number may be the same and the make may be different.

I also have the data in each sheet showing the customer number make and new
is there own respective columns.

I need the first sheet to lookup the other 14 sheets and if the data has the
same customer number but a different make and used instead of new then bring
the value to the first sheet. Keeping in mind there may be a few different
occurances of that customer number within the other 14 sheets. eg: one
customer could have bought a TO or a CH or both and I want the first sheet to
reflect that.