| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up part of a number within a serial number and cpy back assoc
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic Serial number | Excel Discussion (Misc queries) | |||
| increase serial number | Excel Worksheet Functions | |||
| Serial number generate | Excel Worksheet Functions | |||
| form serial number | Excel Discussion (Misc queries) | |||
| generate serial number | Excel Worksheet Functions | |||
Threaded Mode
