drop box/data validation help

[eastland12]

I am working on an estimating sheet and have several values that ar
dependent on the size of the stock. I set up a set of 3 drop down box'
using data validation to progressively narrow down to the correct lis
and am happy with how these drop boxes work.

However how do I use the selection of the final drop box to fill i
dependent values in another part of the sheet?

I have attached the start of my sheet if that helps and the value
currently in the columns on the ref data sheet are each different fo
testing only, want to make sure it works before I go thru and put actua
values in.

Greatly appreciate any help I can get on this.

thanks,

Joh