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
<tbody>
</tbody>
Sheet_2: table for lookup array
<tbody>
</tbody>
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 |
<tbody>
</tbody>
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 |
<tbody>
</tbody>