|
Extracting data
Hi Mark
If I understand you correct Try this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark" wrote in message ... I am having trouble figuring out how to extract certian data from one sheet and display onto a different. I have: model # desc 123 11 aaaa 123 02 ssss 456 63 dddd 456 78 ffff 789 98 gggg 789 97 hhhh On a seperate worksheet I want to put Model-123 in A1 and have all #'s and desc's populate that match 123. any help will be appreciated |
Extracting data
I dont want to create new sheets. This is going to be used
as a reference. I was originally using a function like =IF(A1=1,"",INDEX(DATA!$E$2:$E$3500,MATCH(PCUA!E6, DATA! $A$2:$A$3500,0),1)). But the new data is not formated to allow this function to work. In sheet 2 I want to type any Model# and return the corisponding data. -----Original Message----- Hi Mark If I understand you correct Try this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark" wrote in message ... I am having trouble figuring out how to extract certian data from one sheet and display onto a different. I have: model # desc 123 11 aaaa 123 02 ssss 456 63 dddd 456 78 ffff 789 98 gggg 789 97 hhhh On a seperate worksheet I want to put Model-123 in A1 and have all #'s and desc's populate that match 123. any help will be appreciated . |
Extracting data
Use Vlookup
Here is a example from a old posting Data range in Sheet1 = A1:C20 for example In Sheet2 A1 : 76050 B1 : =VLOOKUP(A1,Sheet1!A1:C20,2,FALSE) It will look for 76050 in the first column of the data range and display the value from the second column (see the number 2 in the formula) C1 : =VLOOKUP(A1,Sheet1!A1:C20,3,FALSE) For the third column -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I dont want to create new sheets. This is going to be used as a reference. I was originally using a function like =IF(A1=1,"",INDEX(DATA!$E$2:$E$3500,MATCH(PCUA!E6, DATA! $A$2:$A$3500,0),1)). But the new data is not formated to allow this function to work. In sheet 2 I want to type any Model# and return the corisponding data. -----Original Message----- Hi Mark If I understand you correct Try this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark" wrote in message ... I am having trouble figuring out how to extract certian data from one sheet and display onto a different. I have: model # desc 123 11 aaaa 123 02 ssss 456 63 dddd 456 78 ffff 789 98 gggg 789 97 hhhh On a seperate worksheet I want to put Model-123 in A1 and have all #'s and desc's populate that match 123. any help will be appreciated . |
Extracting data
Stupid from me this is not working because you have duplicate Model numbers
Why don't you use DataAutoFilter -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Use Vlookup Here is a example from a old posting Data range in Sheet1 = A1:C20 for example In Sheet2 A1 : 76050 B1 : =VLOOKUP(A1,Sheet1!A1:C20,2,FALSE) It will look for 76050 in the first column of the data range and display the value from the second column (see the number 2 in the formula) C1 : =VLOOKUP(A1,Sheet1!A1:C20,3,FALSE) For the third column -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I dont want to create new sheets. This is going to be used as a reference. I was originally using a function like =IF(A1=1,"",INDEX(DATA!$E$2:$E$3500,MATCH(PCUA!E6, DATA! $A$2:$A$3500,0),1)). But the new data is not formated to allow this function to work. In sheet 2 I want to type any Model# and return the corisponding data. -----Original Message----- Hi Mark If I understand you correct Try this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark" wrote in message ... I am having trouble figuring out how to extract certian data from one sheet and display onto a different. I have: model # desc 123 11 aaaa 123 02 ssss 456 63 dddd 456 78 ffff 789 98 gggg 789 97 hhhh On a seperate worksheet I want to put Model-123 in A1 and have all #'s and desc's populate that match 123. any help will be appreciated . |
Extracting data
I thought of that but there are 100's of models.. The
drop down on a filter is just to much to look at. -----Original Message----- Stupid from me this is not working because you have duplicate Model numbers Why don't you use DataAutoFilter -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Use Vlookup Here is a example from a old posting Data range in Sheet1 = A1:C20 for example In Sheet2 A1 : 76050 B1 : =VLOOKUP(A1,Sheet1!A1:C20,2,FALSE) It will look for 76050 in the first column of the data range and display the value from the second column (see the number 2 in the formula) C1 : =VLOOKUP(A1,Sheet1!A1:C20,3,FALSE) For the third column -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I dont want to create new sheets. This is going to be used as a reference. I was originally using a function like =IF(A1=1,"",INDEX(DATA!$E$2:$E$3500,MATCH(PCUA! E6,DATA! $A$2:$A$3500,0),1)). But the new data is not formated to allow this function to work. In sheet 2 I want to type any Model# and return the corisponding data. -----Original Message----- Hi Mark If I understand you correct Try this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark" wrote in message ... I am having trouble figuring out how to extract certian data from one sheet and display onto a different. I have: model # desc 123 11 aaaa 123 02 ssss 456 63 dddd 456 78 ffff 789 98 gggg 789 97 hhhh On a seperate worksheet I want to put Model-123 in A1 and have all #'s and desc's populate that match 123. any help will be appreciated . . |
| All times are GMT +1. The time now is 07:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com