EXCEL DATA VALIDATION

Hi, The easiest way of doing this would be to use INDIRECTfor data validation for Column Y. Simpler if you could remove the spaces from your options in Column (Ie. Could This be Beam,Angle,Channel)? If that works then just use defined names to name each of the ranges for the options in Y to match the option in X (So you'd have a named range Beam containing the Beam options, a named range Angle containing the angle options, etc). You can then set data validation in the Y to be of type list with the source as =INDIRECT(X2) (Assuming that the first data validation list is in X2). Simple sample attached.

If you want to keep this as I Beam, C Channel, L Angle then the formula for data validation in Y needs to be =INDIRECT(RIGHT(X2,LEN(X2)-2)) to remove the first 2 digits (Comes down to defined names not allowing spaces).