Hello,
This is my first post regarding an issue I've had for some time. I'm looking for formula that provides the Item # after first finding the correct Type then finding where the cost falls within that range. I'm thinking that a combination a Index/Match and vlookup would be best. There are hundreds of products and the cost range can vary greatly. Any assistance would be greatly appreciated!
<tbody>
</tbody>
This is my first post regarding an issue I've had for some time. I'm looking for formula that provides the Item # after first finding the correct Type then finding where the cost falls within that range. I'm thinking that a combination a Index/Match and vlookup would be best. There are hundreds of products and the cost range can vary greatly. Any assistance would be greatly appreciated!
Description: | Product 1 | ||
Cost: | $30 | ||
Item #: | ? | ||
Description | Min Cost | Max Cost | Item # |
Product 1 | 1 | 25 | 100001 |
Product 1 | 26 | 50 | 100005 |
Product 1 | 51 | 75 | 100030 |
Product 2 | 1 | 25 | 100033 |
Product 2 | 26 | 50 | 100004 |
Product 2 | 51 | 75 | 100009 |
<tbody>
</tbody>