Multiple column Lookup
Posted on 2013-06-17
I want to lookup a value in a table and place it into a specific column. The lookup is to match two different values from two different columns. For instance:
I have a source table with three columns: (there are many more values that that shown here, but this should be enough for the example.
Task SubTask Title
0007 01 Subtask A Title
0007 02 SubTask B Title
0007 03 Subtask C Title
The table to place the values in has three columns with the same names.
Task SubTask SubTask Title
So if I have 0007 in the Task column AND 02 in the SubTask column, I will get "SubTask B Title" in the Subtask Title column. Kind of like a double VLOOKUP.