Hi,

I have a problem with data validation. My validation is dependant on two
seperate cells. I have created two lists, the first is a list of beam types,
the second is a list of beam sizes. Now what i want to be able to do is allow
the user to select a beam type and then select a beam size and have the
correct cross sectional area appear in a seperate cell.

Can anyone give me a formula to allow me to do this?

Thanks in advance!