Reader’s Questions - Performing two-way look up

Question:

I have - Table 1 and Table 2

How can I bring salary information in table 2 from table 1 for corresponding dept and jobcode?
Thanks
Bob Lee

Our take on this excel problem

You can join Department and Job Code in both table 1 as well as 2 using concatenate function. And then using vlookup function, you can look up salary from table 1 for a particular department and job code in table 2 as shown below:

Step 1: Concatenate column B and column C

Step 2: Vlookup on the new concatenate column just created

Hope this helps.