jimbomcmucka
New Member
- Joined
- Oct 11, 2022
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hey all,
This is my first post, but have used the forum loads in the past to find help with my excel problems. I'm hoping you can help with a problem. Forgive me if I am not explaining the issue very well.
I have created the below formula to retrieve some data from an extract, housed in a different tab:
=INDEX('OTMM ISM Data Extract'!1:1048576,MATCH(B2,'OTMM ISM Data Extract'!E:E,0),MATCH("Assembled Depth Value",'OTMM ISM Data Extract'!$A$1:$MA$1,0))
It works fine, however I have hit an issue. It turns out the extract that is dumped into the other tab doesn't order its columns consistently. So, I need a way to make this look up the row for the column named "GTIN".
Thanks in advance for any suggestions!!
This is my first post, but have used the forum loads in the past to find help with my excel problems. I'm hoping you can help with a problem. Forgive me if I am not explaining the issue very well.
I have created the below formula to retrieve some data from an extract, housed in a different tab:
=INDEX('OTMM ISM Data Extract'!1:1048576,MATCH(B2,'OTMM ISM Data Extract'!E:E,0),MATCH("Assembled Depth Value",'OTMM ISM Data Extract'!$A$1:$MA$1,0))
It works fine, however I have hit an issue. It turns out the extract that is dumped into the other tab doesn't order its columns consistently. So, I need a way to make this look up the row for the column named "GTIN".
Thanks in advance for any suggestions!!