Hi All,
I'm having a blank brain day... I'm sure I've done this before, but can't think what way worked best.
I have a master data table (Full List Master) with item names in Column A, then various headers across the table columns B-BZ
with all the relevant data in the rows below.
In a new sheet i want to create a smaller result table that matches against the name in Column A (lets choose Cell A10) and then search for the result from the column that matches the new sheets column header (lets make that ref 2020)
I could use - =INDEX('MD - Asset Type'!G:G,MATCH($E2,Asset_MS_Ref,0))
but that needs to choose the specific column (G:G) for every header i need...
Is there a simpler option to use I have forgotten, or not learnt properly yet?
TIA
I'm having a blank brain day... I'm sure I've done this before, but can't think what way worked best.
I have a master data table (Full List Master) with item names in Column A, then various headers across the table columns B-BZ
with all the relevant data in the rows below.
In a new sheet i want to create a smaller result table that matches against the name in Column A (lets choose Cell A10) and then search for the result from the column that matches the new sheets column header (lets make that ref 2020)
I could use - =INDEX('MD - Asset Type'!G:G,MATCH($E2,Asset_MS_Ref,0))
but that needs to choose the specific column (G:G) for every header i need...
Is there a simpler option to use I have forgotten, or not learnt properly yet?
TIA