Solved: Multi Column Filtering/vLookup

1

I am trying to get data from a table, based on the values of two columns in another table. I am unable to get filter, vlookup etc. to work.

What am i missing?

For context -

I have a table A (Assembly Strength) with columns ‘Date’, ‘Assembly’ and ‘Vote Strength’

I have a table B (Judgements) with columns that include ‘Date’ and ‘Assembly’

I would like to pull in Vote Strength from Table A into Table B

Thanks guys

2

Hi @Martyn_Thomas,

If I correctly got your point, the formula in the Grater Majority column should be:
[Synod Assembly Strength].Filter(Assembly=thisRow.Assembly && Date=thisRow.Date).[Final Greater Majority] .

Further, if you want the column to keep the numeric value, it can simply be a number (not a lookup) column.

Let me know if it helps.

Cheers!

1 Like
3

Amazing - That’s perfect, thanks for your help

1 Like
4

Happy it worked :+1:

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.