PRODUCT Dose
Flouroracil 4100
Flouroracil 400
There is another list which I have sorted by product (alphabetical ascending) and dose (in descending order)
PRODUCT
Flouroracil 2500
Flouroracil 1000
Flouroracil 500
Problem is to find each product from the first list and bring over the closest 'higher' amount for each product. If the second list only had two dose quantities, a simple VLookup works fine. But in this case, if I use a VLookup on the third item from the first list, and say that if the dose qty is less than the VLookup result, it will return 2500, when I need it to return 500. Does this make any sense?
Thanks!
Flouroracil 4100
Flouroracil 400
There is another list which I have sorted by product (alphabetical ascending) and dose (in descending order)
PRODUCT
Flouroracil 2500
Flouroracil 1000
Flouroracil 500
Problem is to find each product from the first list and bring over the closest 'higher' amount for each product. If the second list only had two dose quantities, a simple VLookup works fine. But in this case, if I use a VLookup on the third item from the first list, and say that if the dose qty is less than the VLookup result, it will return 2500, when I need it to return 500. Does this make any sense?
Thanks!