Easy Problem For Someone

corppunishment11

New Member
Joined
Dec 7, 2018
Messages
29
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
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
927
Office Version
365, 2010
If you're looking for E1 (e.g., Ricky) and F1 (e.g., Wonder Bread), then G1 could be:
Code:
=SUMPRODUCT((E1=$A$1:$A$4)*(F1=$B$1:$B$4)*($C$1:$C$4))
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
927
Office Version
365, 2010
Alternatively, you might try something like this where the match is based on looking for A1 and B1:

XLOOKUP_info.xlsm
ABC
1Jerry SeinfeldHBO6500
2George CostanzaNBC Affiliates10000
3Jerry SeinfeldNBC Affiliates2000
4Ron BurgundyUniversal Pictures5000
5Ricky BobbyWonder Bread2500
6Jerry SeinfeldHBO6500
Sheet6
Cell Formulas
RangeFormula
C1C1=SUMPRODUCT((A1=$A$2:$A$10)*(B1=$B$2:$B$10)*($C$2:$C$10))
 

corppunishment11

New Member
Joined
Dec 7, 2018
Messages
29
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

Well-known Member
Joined
May 8, 2018
Messages
927
Office Version
365, 2010
Don't understand "kick out"
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
927
Office Version
365, 2010
Maybe you mean this?

XLOOKUP_info.xlsm
ABC
1Jerry SeinfeldHBO6500
2George CostanzaNBC Affiliates10000
3Jerry SeinfeldNBC Affiliates2000
4Ron BurgundyUniversal Pictures5000
5Ricky BobbyWonder Bread2500
6Jerry SeinfeldHBO6500
7Jerry SeinfeldHBO2000
Sheet6
Cell Formulas
RangeFormula
C1C1=SUMPRODUCT((A1=$A$2:$A$10)*(B1=$B$2:$B$10)*($C$2:$C$10)*($C$2:$C$10>4000))
 

corppunishment11

New Member
Joined
Dec 7, 2018
Messages
29
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.
 

Forum statistics

Threads
1,089,642
Messages
5,409,489
Members
403,266
Latest member
HMR120

This Week's Hot Topics

Top