Dynamic Column reference in filter command?

[PrimePorkchop]

I am using the "Filter" formula and would like to make the "reference" to a particular column in a table be dynamic, so that I don't have to have different formulas on different tabs - I can just make the fomrula reference a cell on each individual tab to get the name of the column needed.

The code I am using is as follows:

Please Login or Register  to view this content.

In this case, I would like "Weight" to be interchangeable with other options that can be decided on different sheets, so instead of referencing TABLE1[WEIGHT] it would reference TABLE1[A3] where A3 is not a name of a column in Table 1, but rather the value of cell A3 on the worksheet.

I've tried a few variations of the following, but am either messing it up - or completely off base... Im' not sure which ><

Please Login or Register  to view this content.

[AliGW]

Gut instinct: INDIRECT function,

e.g. INDIRECT("Table1["&$A3&"]"

However ...

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

The code I am using ...

... is a formula, not code. Semantics, I know, but code is what is created in VBA or PowerQuery.

[PrimePorkchop]

I've attached an example that outlines what I am trying to do w/ the "FILTER" formula.

Thank you!

[wk9128]

worksheet name : formula

Cell E4 formula

Please Login or Register  to view this content.

[Bo_Ry]

Please try

=FILTER(data!A2:A8,(data!C2:C8=B2)*(FILTER(Table1,data!A1:L1=B3)="Y"))