performing multidimensional lookups
As part of my ETL, I wish to take two or more attributes and map them to a lookup table, find a particular value, and then add that new value back into a new attribute. In Excel, it looks like this (with some random reference cells):
So this uses an array on Sheet1 as a multidimensional lookup table. It then takes the values of E3, G3 and J3 and looks them up on Sheet1 in columns C, B and E. When it finds a match, it goes to column 24 and returns the value of that cell.
How can I do this on RM?