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!
Sheet_1: table with lookup value (item) and want to return value to
Order, Selection_Date, Selection_#, Returned_Reason
X 9/5 1 Fix
X 9/7 5 Clean
X 9/5 3 Fix
X 9/7 8 Clean
Y 9/10 2 Clean
Y 9/11 5 Upgrade
Sheet_2: table for lookup array
Order, Request_Date, Total_#_Requested, Reason
X 9/4 3 Fix
X 9/5 6 Clean
Y 9/7 3 Clean
Y 9/8 2 Upgrade
Bookmarks