Basically I have a column of employee's names and then a row of other criteria. On a second sheet, I have the column of employee's names again, plus a column which would contain the same criteria, and a third column with a number.
If the name matches and then the two other criteria match, I want it to pull that number from the third column.
Here's an example:
TAB 1:
<tbody>
</tbody>
TAB 2:
<tbody>
</tbody>
So I would like it say... If A3 on first tab matches a name in column A of tab 2 AND if B2 from first tab matches an item from column B of tab 2, then to pull the associated number from column 3 of tab 2.
Any ideas please?
If the name matches and then the two other criteria match, I want it to pull that number from the third column.
Here's an example:
TAB 1:
1 | A | B | C | D |
2 | Name | Thing 1 | Thing 2 | Thing 3 |
3 | Smith, Joe | |||
4 | Robert, Bob |
<tbody>
</tbody>
TAB 2:
1 | A | B | C |
2 | Name | All Things | Amount |
3 | Smith, Joe | Thing 1 | 5 |
4 | Smith, Joe | Thing 2 | 3 |
5 | Smith, Joe | Thing 3 | 2 |
6 | Robert, Bob | Thing 2 | 1 |
<tbody>
</tbody>
So I would like it say... If A3 on first tab matches a name in column A of tab 2 AND if B2 from first tab matches an item from column B of tab 2, then to pull the associated number from column 3 of tab 2.
Any ideas please?