BlueJayGene
New Member
- Joined
- Feb 26, 2012
- Messages
- 10
I have two workbooks – and wish to extract data from the first workbook (second tab), and insert certain cell data into a specific cell in the second workbook (first tab).</SPAN>
The first workbook has this info: </SPAN>
<TBODY>
</TBODY>
This is a very large data set. The S/N will appear multiple times. The rest of the data will change with each entry, but there are some exceptions where it may be the same.</SPAN>
The second workbook has this data:</SPAN>
<TBODY>
</TBODY>
This too is a very large data set. What I need to do is to find the S/N in the first table – based on the month – and replace the entry under Customer 1 with the associated Customer 2 data entry.</SPAN>
The VLOOKUP function can’t seem to handle the multiple S/N entries.</SPAN>
Any suggestions?</SPAN>
The first workbook has this info: </SPAN>
SN</SPAN></SPAN> | SN Sort</SPAN></SPAN> | P/N</SPAN></SPAN> | Removal</SPAN></SPAN> | Customer 1</SPAN></SPAN> | Customer 2</SPAN></SPAN> | Program</SPAN></SPAN> | Rec Month</SPAN></SPAN> |
ABCD1234</SPAN></SPAN> | D1234</SPAN></SPAN> | 1234567899</SPAN></SPAN> | Scheduled</SPAN></SPAN> | Customer A</SPAN></SPAN> | Customer B</SPAN></SPAN> | Block 10</SPAN></SPAN> | Nov-13</SPAN></SPAN> |
ABCC5432</SPAN></SPAN> | C5432</SPAN></SPAN> | 1234569765</SPAN></SPAN> | Unscheduled</SPAN></SPAN> | Customer C</SPAN></SPAN> | Customer J</SPAN></SPAN> | Block 8</SPAN></SPAN> | Nov-13</SPAN></SPAN> |
ABCD1234</SPAN></SPAN> | D1234</SPAN></SPAN> | 1234567899</SPAN></SPAN> | Scheduled</SPAN></SPAN> | Customer A</SPAN></SPAN> | Customer C</SPAN></SPAN> | Block 10</SPAN></SPAN> | Dec-13</SPAN></SPAN> |
ABCC5432</SPAN></SPAN> | C5432</SPAN></SPAN> | 1234569765</SPAN></SPAN> | Unscheduled</SPAN></SPAN> | Customer C</SPAN></SPAN> | Customer K</SPAN></SPAN> | Block 8</SPAN></SPAN> | Dec-13</SPAN></SPAN> |
<TBODY>
</TBODY>
This is a very large data set. The S/N will appear multiple times. The rest of the data will change with each entry, but there are some exceptions where it may be the same.</SPAN>
The second workbook has this data:</SPAN>
ID</SPAN></SPAN> | S/N</SPAN></SPAN> | A</SPAN></SPAN> | B</SPAN></SPAN> | P/N</SPAN></SPAN> | Born-on-Date</SPAN></SPAN> | Date Rec</SPAN></SPAN> | Ship Date</SPAN></SPAN> | Customer 1</SPAN></SPAN> |
123456</SPAN></SPAN> | ABCD1234</SPAN></SPAN> | 1 thru 14</SPAN></SPAN> | Yes or No</SPAN></SPAN> | 1234567899</SPAN></SPAN> | 03/10/2007</SPAN></SPAN> | 11/07/2013</SPAN></SPAN> | 11/22/2013</SPAN></SPAN> | Customer A</SPAN></SPAN> |
123457</SPAN></SPAN> | ABCC5432</SPAN></SPAN> | 1 thru 14</SPAN></SPAN> | Yes or No</SPAN></SPAN> | 1234569765</SPAN></SPAN> | 04/25/2011</SPAN></SPAN> | 11/14/2013</SPAN></SPAN> | 11/26/2013</SPAN></SPAN> | Customer C</SPAN></SPAN> |
123458</SPAN></SPAN> | ABCD1234</SPAN></SPAN> | 1 thru 14</SPAN></SPAN> | Yes or No</SPAN></SPAN> | 1234567899</SPAN></SPAN> | 09/23/2012</SPAN></SPAN> | 12/06/2013</SPAN></SPAN> | 12/14/2013</SPAN></SPAN> | Customer A</SPAN></SPAN> |
123459</SPAN></SPAN> | ABCC5432</SPAN></SPAN> | 1 thru 14</SPAN></SPAN> | Yes or No</SPAN></SPAN> | 1234569765</SPAN></SPAN> | 01/07/2005</SPAN></SPAN> | 12/12/2013</SPAN></SPAN> | 12/31/2013</SPAN></SPAN> | Customer C</SPAN></SPAN> |
<TBODY>
</TBODY>
This too is a very large data set. What I need to do is to find the S/N in the first table – based on the month – and replace the entry under Customer 1 with the associated Customer 2 data entry.</SPAN>
The VLOOKUP function can’t seem to handle the multiple S/N entries.</SPAN>
Any suggestions?</SPAN>