Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Header or Footer to show up on multiple sheets in a document | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Weighted Avg - using values from multiple sheets | Excel Worksheet Functions | |||
how do changes made on shared sheets show up in a master sheet? | Excel Worksheet Functions |