Lookup Table Help

[jwallen23]

Hi All, I'm trying to do a relatively simple lookup to fill in a table using another master table with all of the possible combinations.

I have a master table with data that looks like this (~1,000,000 records, 3 fields)

Item 1	Item 2	Result
0001	0001	5
0001	0002	7
0001	0003	3
etc.	etc.	etc.

And I'm trying to fill in a table that looks like this (30x200). I need it to lookup each one and fill in the cell with the result (then export to a csv, Excel, etc.), but can't get it to work.

	0001	0002	0003	0004	0005	0006
0001
0002
0003

[JamesCharnley]

Hi @jwallen23 

I think this is what you want, and this should work as a logic with no more steps if you have no duplicate cells:

I'm transposing the master table so I can join it onto the other table, putting the result in the correct column, and then cross tabbing it back.

[Emmanuel_G]

@jwallen23 

Find in attachement the way of doing that.