P
PCSteele
I am using my own version of the formula in this exampl
=INDEX(A2:C5,MATCH(part number,A2:A5,0),3
to find out the location of items with a particular part number for Orders, on the same row I have the quantity of that part number. Is there a way I can use this to then search to see if the location has enough parts to complete an order
My problem is that sometimes the parts are in two or more locations, but some locations have enough items while others don't so I want to find and display the location that does have enough parts.
=INDEX(A2:C5,MATCH(part number,A2:A5,0),3
to find out the location of items with a particular part number for Orders, on the same row I have the quantity of that part number. Is there a way I can use this to then search to see if the location has enough parts to complete an order
My problem is that sometimes the parts are in two or more locations, but some locations have enough items while others don't so I want to find and display the location that does have enough parts.