JDJohnson8783
New Member
- Joined
- Jul 5, 2023
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
I need some help please. I am looking for a excel formula that will determine the parent of a child based off a number/period outline on sheet 1 (yellow column sheet 1 "Item No.") and take the part number of the parent (orange column sheet 1 or yellow column sheet 2) and populate a column with the parent part number (green column sheet 2).
Sheet 1 looks like this:
Sheet 2 looks like this:
I need the parent part number to be placed into the row of the child in the parent column. Ideally the parent part number will match the part number on sheet 2 rather than sheet 1. If it is easier to pull the parent part number from sheet 1 I can concatenate the last 2 characters that are in sheet 2.
Please let me know if you have any questions. Been working on this for 4 days.
Sheet 1 looks like this:
Sheet 2 looks like this:
I need the parent part number to be placed into the row of the child in the parent column. Ideally the parent part number will match the part number on sheet 2 rather than sheet 1. If it is easier to pull the parent part number from sheet 1 I can concatenate the last 2 characters that are in sheet 2.
Please let me know if you have any questions. Been working on this for 4 days.