Cheeky_Monkey
New Member
- Joined
- Aug 9, 2019
- Messages
- 4
I've tried really hard to find an answer to this problem but cannot find it.
Basically I have an table which is populated as below:
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
Now I want to find the Band of a particular product based upon its Qty. I have used Match(Criteria, Range, 1) to find the Band for a particular product group. However this works on one line. But my search line will vary depending on the Product group of the item. i could use multiple ifs but I have many more product groups.
What I need to do is identify the product group an item belongs to and then match on that line.
E.g
Item A belongs to Group C and 33 QTY sold = Band 2
Item C belongs to Group E and 33 QTY sold = Band 1
Thanks in advance
Basically I have an table which is populated as below:
Band 1 | Band 2 | Band 3 | Band 4 | Band 5 | |
Product Group A | 10 | 25 | 40 | 55 | 60 |
Product Group B | 15 | 20 | 25 | 35 | 40 |
Product Group C | 25 | 30 | 35 | 40 | 45 |
Product Group D | 100 | 150 | 200 | 250 | 300 |
Product Group E | 50 | 60 | 70 | 80 | 90 |
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
Now I want to find the Band of a particular product based upon its Qty. I have used Match(Criteria, Range, 1) to find the Band for a particular product group. However this works on one line. But my search line will vary depending on the Product group of the item. i could use multiple ifs but I have many more product groups.
What I need to do is identify the product group an item belongs to and then match on that line.
E.g
Item A belongs to Group C and 33 QTY sold = Band 2
Item C belongs to Group E and 33 QTY sold = Band 1
Thanks in advance