I tried searching, but can’t seem to find the exact circumstance, so I’m reaching out here. Please bear with me I’m using the TableName[ColumnName] format for clearer understanding
need all row values of TableC[INV Num] when:
value of row TableC[TableB KEYID] equals “X”
“X” equals the TableB[KEY ID] when TableA[KEY ID] equals “Y”
“Y” equals the TableA[KEY ID] when on [_THISROW]
I have 3 tables. In TableA, I am trying to get the values of every row in Table C where the value of a certain column matches the value of a column in TableB, which in turn, matches a column in TableA.
I’ve made a sample of how this all translates back into Excel, and I just need a little help figuring out the expressions to use. The real tables have multiple columns that aren’t represented here because they are unimportant to the issue at hand. Thank you!