Vlookup based on lookup value and multi number criteria

randrze2

New Member
Joined
Jul 8, 2014
Messages
11
I have been stuck with this problem for a while. What I am trying to do is return a reason based on an Order. How it works is that an Order is placed and may have multiple line items which would have a total number of units but when the Order is actually selected, it is done so randomly but shows which Order number was chosen. For example, in Sheet_2, Order X has 2 line items so the total number of units ordered is 9. The first 3 have a reason of "Fix" and the next 6 have a reason of "Clean". Then in Sheet_1, I am trying to return the Reason from Sheet_2 but the problem I am having is that Sheet_1 contains the specific selection number which I cannot figure out a way to work around. Any help is greatly appreciated. Thanks!
:confused::confused::confused::confused:




Sheet_1: table with lookup value (item) and want to return value to
OrderSelection DateSelection #Returned Reason
X9/51Fix
X9/75Clean
X9/53Fix
X9/78Clean
Y9/102Clean
Y9/115Upgrade

<tbody>
</tbody>



Sheet_2: table for lookup array
OrderRequest DateTotal # RequestedReason
X9/43Fix
X9/56Clean
Y9/73Clean
Y9/82Upgrade

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,090,045
Messages
5,412,026
Members
403,409
Latest member
IHRAcer

This Week's Hot Topics

Top