Reader’s Questions - Performing two-way look up
Clever Excel formulas March 16th, 2009
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.
Share ThisPopularity: 27%
there is another way that uses array formula. This method does not require a new column:
sum(($A$4:$A$13=A17)*($B$4:$B$13=B17)*($C$4:$C$13))