# Easy Problem For Someone

#### corppunishment11

##### New Member
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

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

### 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
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
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
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
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
Don't understand "kick out"

#### kweaver

##### Well-known Member
Maybe you mean this?

XLOOKUP_info.xlsm
ABC
1Jerry SeinfeldHBO6500
2George CostanzaNBC Affiliates10000
3Jerry SeinfeldNBC Affiliates2000
4Ron BurgundyUniversal Pictures5000
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
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.