babypink2807
New Member
- Joined
- Jul 13, 2015
- Messages
- 42
- Office Version
- 2016
Hi
I have a workbook with two worksheets. 1st worksheet (TAB1) has all my "machines" identified by its serial number, one record per machine.
On my second sheet (TAB2) has multiple machines to one record. Unfortunately, the data for the serial numbers (multiple) exports in to one column and are separated by a comma. I then convert the column to text and have ended up with an extra 32 columns most of which are serial numbers. So I have one record some with 32 columns (for each individual serial number) and some records from anything between 1 column and 32.
The goal is to match the serial number in TAB 1, to the serial numbers in TAB2 and pull through that data from TAB2. I have done it and it feels very long winded, and then I have to create a Power Query (Using youtube!) to bring all that data together
My question is, can Vlookup from TAB1, lookup a column with multiple serial numbers in? Then pull through that data or; can Vlookup look up multiple columns and pull the data through
I had to do this 2 weeks ago and took me 2 days to do, now they want it again with extra data and I am losing the will to live
Thank you
I have a workbook with two worksheets. 1st worksheet (TAB1) has all my "machines" identified by its serial number, one record per machine.
On my second sheet (TAB2) has multiple machines to one record. Unfortunately, the data for the serial numbers (multiple) exports in to one column and are separated by a comma. I then convert the column to text and have ended up with an extra 32 columns most of which are serial numbers. So I have one record some with 32 columns (for each individual serial number) and some records from anything between 1 column and 32.
The goal is to match the serial number in TAB 1, to the serial numbers in TAB2 and pull through that data from TAB2. I have done it and it feels very long winded, and then I have to create a Power Query (Using youtube!) to bring all that data together
My question is, can Vlookup from TAB1, lookup a column with multiple serial numbers in? Then pull through that data or; can Vlookup look up multiple columns and pull the data through
I had to do this 2 weeks ago and took me 2 days to do, now they want it again with extra data and I am losing the will to live
Thank you