Lookup data from table B based on formula in table A

[Lars_Harmsen]

Hi!

I’m trying to figure out a way to get data from ‘Table B’ to ‘Table A’ based on the value of a field in Table A.

It looks as follows:
I have an entry in Table A, for which I select ‘device’, ‘pagetype’ and ‘country’. For the combination of these three fields I want to create a unique identifier, so I’ve added a formula column:

This would result in for example MobileHomepageGermany.

In Table B I have set a ‘value’ for MobileHomepageGermany of 100. I want to lookup this value and add it to a column in Table A.

So I add an entry, select device, page, and country, and then I want the value to show up in that Table in that row.

I’ve been trying to figure this out for 1,5 hours, but its probably a simple solution right?

Thanks in advance.