What I want is:
In Cell B2 you choose a size ( eg 1/2" ) from the drop down
In Cell C2 you choose a material either 304 or 316.

what I want is from B2 it will generate a vlook up for either 304 or 316
material depending on cell c2.... Not sure how to do this????
--
Donna