S
Seantastic
I have a spreadsheet with 2 tabs.
First tab is named “inventoryâ€
In column “H†the are serial numbers in the following formats
ABBC.1234567
ABBC.1234567_RM
ABBC.1234567_FT
The only part of the serial number that interests me is the middle numbers
(i.e. 1234567)
In column “A†I have a list of “part codeâ€
In my second tab called “partsâ€
In column E there is a list of the middle numbers found in the first tab
(i.e. 1234567)
In my I would like to look up the number in Column “E†from sheet “partsâ€
(my second tab) that is found somewhere in column “H†in the middle of the
serial number in sheet “inventoryâ€, get the associated “part code†from
column “A†and copy it back into sheet “parts†(my second tab) in column “Lâ€
Sheet “inventoryâ€
A H
123 ABBC.1234467
456 ABBC.1234547_RM
897 ABBC.1234564_FT
Sheet “partsâ€
E L
1234547 456
1234564 897
1234467 123
First tab is named “inventoryâ€
In column “H†the are serial numbers in the following formats
ABBC.1234567
ABBC.1234567_RM
ABBC.1234567_FT
The only part of the serial number that interests me is the middle numbers
(i.e. 1234567)
In column “A†I have a list of “part codeâ€
In my second tab called “partsâ€
In column E there is a list of the middle numbers found in the first tab
(i.e. 1234567)
In my I would like to look up the number in Column “E†from sheet “partsâ€
(my second tab) that is found somewhere in column “H†in the middle of the
serial number in sheet “inventoryâ€, get the associated “part code†from
column “A†and copy it back into sheet “parts†(my second tab) in column “Lâ€
Sheet “inventoryâ€
A H
123 ABBC.1234467
456 ABBC.1234547_RM
897 ABBC.1234564_FT
Sheet “partsâ€
E L
1234547 456
1234564 897
1234467 123