Argonous
New Member
- Joined
- Sep 23, 2004
- Messages
- 15
- Office Version
- 2019
- Platform
- Windows
Hello everyone,
I need help with a complicated formula (for me at least). I a trying to separate and remove data from a cell in one sheet based on data in another. I have successfully been able to pull out the Bldg data from the other sheet using INDEX/MATCH if the Bldg code is the first two characters, which in most cases it is. What I am struggling with is getting the desired data in the Room and Loc columns as well as the removal of the "junk" data based on a column in another sheet called Data.
Here is what I need the formula(s) to do:
Let me know what you can come up with.
Thanks everyone!
I need help with a complicated formula (for me at least). I a trying to separate and remove data from a cell in one sheet based on data in another. I have successfully been able to pull out the Bldg data from the other sheet using INDEX/MATCH if the Bldg code is the first two characters, which in most cases it is. What I am struggling with is getting the desired data in the Room and Loc columns as well as the removal of the "junk" data based on a column in another sheet called Data.
Here is what I need the formula(s) to do:
- Remove any characters before the building code (DS-, X) designated in the Bldg column of the Data sheet.
- After step 1, extract the first two characters of the data and place it in the Bldg column (done already with INDEX/MATCH if junk data not present).
- Split the Loc data from the cell (01, 02, A1-1) and place it in the Loc column.
- Remove any additional "junk" data as specified in the Remove column of the other sheet called Data.
Let me know what you can come up with.
Thanks everyone!