My Spreadsheet contains printer specifications in blocks that I need to add in to my inventory
A formula reads these blocks and extracts each attribute.
My Formula does the following:
The problem is some of my specification blocks do not have a certain keyword such as Power
Block 1 - Power Keyword
Block 2 - No power
Block 3 - Power Keyword
My formula is returning the second instance of power but it belongs to block 3
My Solution:
Ideal Result
Block 1 Found Power keyword so return adjacent cell value of AC 230V
Block 2 Did not find power so return blank
Block 3 Found Power keyword so return adjacent cell value of AC 110/230 V ( 50/60Hz )
Is there a way to modify my formula to make it return the correct values?
A formula reads these blocks and extracts each attribute.
My Formula does the following:
- Grabs a keyword from a cell
- Finds the first instance of that keyword and returns the value in the opposite cell
The problem is some of my specification blocks do not have a certain keyword such as Power
Block 1 - Power Keyword
Block 2 - No power
Block 3 - Power Keyword
My formula is returning the second instance of power but it belongs to block 3
My Solution:
- Make the formula smarter
- Before each block put a keyword such as Main Specification so formula can count the blocks, block 1,2,3 etc
- Formula then finds block 1 keyword 1, block 2 keyword 2 etc
Ideal Result
Block 1 Found Power keyword so return adjacent cell value of AC 230V
Block 2 Did not find power so return blank
Block 3 Found Power keyword so return adjacent cell value of AC 110/230 V ( 50/60Hz )
Is there a way to modify my formula to make it return the correct values?