Forum Discussion
Help with Linking Columns
I have another question for all you geniuses. As you can see i have a master chart here and im trying to link a whole column to another worksheet based on the selection of what "Engine" they s...
In effect, you suggest using INDEX-CHOOSE. I love CHOOSE but it becomes unnecessary with INDEX using the Reference form.
True. I suggested CHOOSE on the assumption that I was reading data from ranges on the different Engine sheets and aggregating them on the master. It now appears more likely that the task is to transfer a heading from the master sheet to the individual sheets.
This uses INDEX/MATCH
= INDEX( Master, MATCH( Engine, Master[Engine:], 0 ), 0 )
where 'Engine' is a sheet-local name that contains 12,13,14 as appropriate and
Master[Engine] is a structured references to the table on the master sheet.
For the record I have also included an alternative form using FILTER that, at present, only works on Office 365 insider.
= FILTER( Master, Master[Engine:]=Engine )