Hello,
I am trying to solve the following in Excel 2013. Using the below table...
<tbody>
</tbody>
... I would like to reassign certain Products with certain Lengths to their correct Segments. As in:
- Both Alfa Products are listed as belonging to Segment C but if the length is greater than 225 then that Alfa product is to be reassigned to Segment D.
- Same goes for the Beta Products however here the Segments are correct from the start.
- And it also depends on the product. Ie for the Charlie Products they stay in Segment B even though the length may be greater than 225.
I already use Vlookup for the above when it suffices to just check what the product is, but here I suspect that Vlookup falls short. So I was looking at some similar cases and was thinking of using Index Match but I can't think of how. Or maybe there is a better idea?
Thanks for any help
I am trying to solve the following in Excel 2013. Using the below table...
Product | Length | Segment |
Alfa | 200 | C |
Alfa | 250 | C (to be reassigned to D) |
Beta | 200 | C |
Beta | 250 | D |
Charlie | 150 | B |
Charlie | 250 | B |
<tbody>
</tbody>
... I would like to reassign certain Products with certain Lengths to their correct Segments. As in:
- Both Alfa Products are listed as belonging to Segment C but if the length is greater than 225 then that Alfa product is to be reassigned to Segment D.
- Same goes for the Beta Products however here the Segments are correct from the start.
- And it also depends on the product. Ie for the Charlie Products they stay in Segment B even though the length may be greater than 225.
I already use Vlookup for the above when it suffices to just check what the product is, but here I suspect that Vlookup falls short. So I was looking at some similar cases and was thinking of using Index Match but I can't think of how. Or maybe there is a better idea?
Thanks for any help