trekker1218
Board Regular
- Joined
- Feb 15, 2018
- Messages
- 86
- Office Version
- 2019
- Platform
- Windows
I am trying to line up columns of data that are all jumbled. Example. length x width x height are in my sheet in a row. But are in different columns. I've tried to Index and match to no avail. How can I search for a cell label marked WIDTH in a row and then get the next cell to the right with the WIDTH VALUE. I am using 2 sheets. one with all the data and a blank. I though I could Index the row and match the data cell.
=INDEX(Sheet2!BG3:FH3,MATCH(BG3,Sheet2!BG3:FH3,FALSE),2)
row of data row of data
this works for my first column only. When i apply it to other columns. its give me an error or no values when I know the values are there.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
=INDEX(Sheet2!BG3:FH3,MATCH(BG3,Sheet2!BG3:FH3,FALSE),2)
row of data row of data
this works for my first column only. When i apply it to other columns. its give me an error or no values when I know the values are there.
Attribute Label 1 | Attribute Value 1 | Attribute Label 2 | Attribute Value 2 | Attribute Label 3 | Attribute Value 3 | Attribute Label 4 | Attribute Value 4 | Attribute Label 5 | Attribute Value 5 | Attribute Label 6 | Attribute Value 6 |
Brand Name | Gastite | Sub Brand | FlashShield | Item Name | Corrugated Tube | Type | Metallically Shielded, Flexible | Nominal Size | 1/2 Inch | Size | #N/A |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>