Lookup values in multipul sheets and show value in another sheet
 

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.

Kim,

This is another example of a case where multiple sheets is a bad idea.

Combine all of your datasheets into one sheet, perhaps adding another column
to show the value used to differentiate your data (use the same criteria as
was used to place the data on the sheets), then use data filters or sorting
to display your similar data.

HTH,
Bernie
MS Excel MVP


"Kim" wrote in message
...
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.

Thanks Bernie, BUT, the reason for so many sheets is that there is a lot of
data and it won't fit on one sheet.



"Bernie Deitrick" wrote:

Kim,

This is another example of a case where multiple sheets is a bad idea.

Combine all of your datasheets into one sheet, perhaps adding another column
to show the value used to differentiate your data (use the same criteria as
was used to place the data on the sheets), then use data filters or sorting
to display your similar data.

HTH,
Bernie
MS Excel MVP


"Kim" wrote in message
...
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.

Kim,

You should consider using Access or any other database program.

HTH,
Bernie
MS Excel MVP

Thanks Bernie, BUT, the reason for so many sheets is that there is a lot
of
data and it won't fit on one sheet.