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>
