Hi,
I have an excel sheet with a list of 'Codes' in Cells G2:G20.
These 'Codes' have a corresponding 'Max Height' value in the corresponding column H.
Column J has a list of values that are designed to have a range of possible heights. What I want to do is to be able to lookup the 'Code' and list (in a drop down box) all possible heights until the 'Max height' has been found (but not greater than).
Any ideas?
I have an excel sheet with a list of 'Codes' in Cells G2:G20.
These 'Codes' have a corresponding 'Max Height' value in the corresponding column H.
Column J has a list of values that are designed to have a range of possible heights. What I want to do is to be able to lookup the 'Code' and list (in a drop down box) all possible heights until the 'Max height' has been found (but not greater than).
Any ideas?