Hello,
I'm looking for help on a formula to retrieve a value from a table based on two criteria. I'm sure there's probably a fairly easy way to do it, but I'm just struggling to find the best way to do it myself so I'm hoping someone here might be able to help.
I have a list of employees in column A and a list of units in column B. Both employees and units can be repeated in the columns, however each combination of the two is unique.
I also have a look-up table with the employee names listed in the rows and the units listed in the columns. What I'm trying to do is create a formula that will pull a value in the lookup table that matches the employee/unit combo in columns A and B.
<tbody>
</tbody>
Lookup table:
<tbody>
</tbody>
Any help is GREATLY appreciated!!
Thanks!
I'm looking for help on a formula to retrieve a value from a table based on two criteria. I'm sure there's probably a fairly easy way to do it, but I'm just struggling to find the best way to do it myself so I'm hoping someone here might be able to help.
I have a list of employees in column A and a list of units in column B. Both employees and units can be repeated in the columns, however each combination of the two is unique.
I also have a look-up table with the employee names listed in the rows and the units listed in the columns. What I'm trying to do is create a formula that will pull a value in the lookup table that matches the employee/unit combo in columns A and B.
A | B | C | |
1 | Employee1 | Unit1 | Value from table that matches criteria in column A and B |
2 | Employee1 | Unit2 | |
3 | Employee1 | Unit3 | |
4 | Employee1 | Unit4 | |
5 | Employee2 | Unit10 | |
6 | Employee2 | Unit11 | |
7 | Employee3 | Unit5 | |
8 | Employee3 | Unit6 | |
9 | Employee3 | Unit7 | |
10 | Employee3 | Unit8 | |
11 | Employee3 | Unit9 | |
12 | Employee3 | Unit10 |
<tbody>
</tbody>
Lookup table:
A | B | C | D | E | F | G | H | I | J | K | |
1 | Unit1 | Unit2 | Unit3 | Unit4 | Unit5 | Unit6 | Unit7 | Unit8 | Unit9 | Unit10 | |
2 | Employee1 | 5,000 | 10,000 | 5,000 | 10,000 | ||||||
3 | Employee2 | 5,000 | |||||||||
4 | Employee3 | 5,000 | 5,000 | 10,000 | 15,000 | 9,000 | 4,000 | ||||
5 | Employee4 | 6,000 | |||||||||
6 | Employee5 | 3,000 | |||||||||
7 | Employee6 | 7,000 | |||||||||
8 | Employee7 | ||||||||||
9 | Employee8 | 17,000 | |||||||||
10 | Employee9 | 4,000 | 5,000 | ||||||||
11 | Employee10 | 15,000 | |||||||||
12 | Employee11 | 2,000 |
<tbody>
</tbody>
Any help is GREATLY appreciated!!
Thanks!