Multiple Criteria Look up Text result

skjolsc

New Member
Joined
Jul 25, 2013
Messages
6
So basically I am looking to build a formula that would take this information and return a text value.

if it could work anything like this sumproduct formula to bring back text that would be awesome:
<CODE>=SUMPRODUCT(--(A1:A10="7654321"),--(B1:B10="ABCDE"),--(C1:C10="3"),D1:D10)

But instead of a formula that returns a sum of values, the return is a single value. The three criteria will always be unique. There will never be a case where there is a duplicate of all three.

Thanks to any and all for the help!</CODE>
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,095,312
Messages
5,443,740
Members
405,247
Latest member
Whatdoidonow

This Week's Hot Topics

Top