Two matching criteria, then pull a number from third column?

[bbarkley]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name[/TD]
[TD]Thing 1[/TD]
[TD]Thing 2[/TD]
[TD]Thing 3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Smith, Joe[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Robert, Bob[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

TAB 2:

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name[/TD]
[TD]All Things[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Smith, Joe[/TD]
[TD]Thing 1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Smith, Joe[/TD]
[TD]Thing 2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Smith, Joe[/TD]
[TD]Thing 3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Robert, Bob[/TD]
[TD]Thing 2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Name[/TD]
[TD]Thing 1[/TD]
[TD]Thing 2[/TD]
[TD]Thing 3[/TD]
[TD][/TD]
[TD]TAB1[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Smith, Joe[/TD]
[TD]

5​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Robert, Bob[/TD]
[TD]

0​

[/TD]
[TD]

1​

[/TD]
[TD]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Name[/TD]
[TD]All Things[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]TAB2[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Smith, Joe[/TD]
[TD]Thing 1[/TD]
[TD]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Smith, Joe[/TD]
[TD]Thing 2[/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Smith, Joe[/TD]
[TD]Thing 3[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Robert, Bob[/TD]
[TD]Thing 2[/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

TAB1

B1=SUMIFS('TAB2'!$C$2:$C$5,'TAB2'!$A$2:$A$5,'TAB1'!$A2,'TAB2'!$B$2:$B$5,'TAB1'!B$1) copy across and down

 

[bbarkley]

That worked, thank you!

 

[MARZIOTULLIO]

You are welcome