I have a price list from a supplier that uses multiple columns depending on
the rating of the item, with the price adjacent to the part number.

Description Small Medium Large
Orange O-S 0.10 O-M 0.15 O-L 0.20
Apple A-S 0.25 A-M 0.35 A-L 0.50

What I want to do is enter a part number in a field (O-M) then go through
the entire price list until it finds the match and then return the adjacent
field value (0.15).

Can anyone help with a solution for this

Thanks