Offset from different possible ranges

[BRISBANEBOB]

I am using cascading drop downs to return a string (product). I also need to return a value (quantity) from a cell to the right of the Product. It should be a simple offset but I can't crack the logic.

Sample attached. Thanks for any assistance.

[2001jesper]

Is the quantity fixed based on the product type?

[Ace_XL]

Try

=INDEX(OFFSET(INDIRECT(A5),,1),MATCH(B5,INDIRECT(A5),0))

[BRISBANEBOB]

Thanks - I knew it had to be somewhere in that mix of formula. Your reputation has been added to.