Hi all,
I am trying to make a formula where by if i type in a keyword such as entrance or bathroom it will already type in the number needed such as width and height of the door way in the relevant field is this possible?

one more thing is it possible for it to grab the data such as the door width and height off a seperate sheet or sheets, or can it only be in one sheet?
Many Thanks
Def