Easy Problem For Someone

[corppunishment11]

Am I able to write a formula to use text in one column to match that text in another column and return the amount in another column? The idea being that there would be multiple entries for the A2 data points.

Example:

A2 B2 C2
George Costanza NBC Affiliates 10,000
Jerry Seinfield NBC Networks 2,000
Ron Burgundy Universal Pictures 5,000
Ricky Bobby Wonder Bread 2,500

So, if A2 is Ricky Bobby and B2 is Wonder Bread then return 2,500

 

[kweaver]

If you're looking for E1 (e.g., Ricky) and F1 (e.g., Wonder Bread), then G1 could be:

=SUMPRODUCT((E1=$A$1:$A$4)*(F1=$B$1:$B$4)*($C$1:$C$4))

 

[kweaver]

Alternatively, you might try something like this where the match is based on looking for A1 and B1:

XLOOKUP_info.xlsm
	A	B	C
1	Jerry Seinfeld	HBO	6500
2	George Costanza	NBC Affiliates	10000
3	Jerry Seinfeld	NBC Affiliates	2000
4	Ron Burgundy	Universal Pictures	5000
5	Ricky Bobby	Wonder Bread	2500
6	Jerry Seinfeld	HBO	6500
Sheet6

Cell Formulas
Range	Formula
C1	C1	=SUMPRODUCT((A1=$A$2:$A$10)*(B1=$B$2:$B$10)*($C$2:$C$10))

 

[corppunishment11]

Great! Thank you!. I'll give some additional details.

I need any Jerry's that match HBO that are higher than a 4,000 in column c to kick out as the number 1.

Does that make sense?

 

[kweaver]

Don't understand "kick out"

 

[kweaver]

Maybe you mean this?

XLOOKUP_info.xlsm
	A	B	C
1	Jerry Seinfeld	HBO	6500
2	George Costanza	NBC Affiliates	10000
3	Jerry Seinfeld	NBC Affiliates	2000
4	Ron Burgundy	Universal Pictures	5000
5	Ricky Bobby	Wonder Bread	2500
6	Jerry Seinfeld	HBO	6500
7	Jerry Seinfeld	HBO	2000
Sheet6

Cell Formulas
Range	Formula
C1	C1	=SUMPRODUCT((A1=$A$2:$A$10)*(B1=$B$2:$B$10)*($C$2:$C$10)*($C$2:$C$10>4000))

 

[corppunishment11]

Hi. Thank you for this. I'm trying to see if this is doing what I need or if I can manipulate it to do so.

I will be sure to report back.