Quote Originally Posted by martindwilson View Post
well this works
=IF('Wall Types'!B3=TRUE, 'Wall Types'!C3,"")
but try this instead

Thanks you very much this appears to work very well. I'll have to dissect your formula (learn from it)and apply it to the rest. It appears I need to learn more about Index and Match functions.

It looks like it may create another issue with the next step but I will try to figure it out myself, (best way for me to learn) If I have an issue I will come back and ask.

Again thank you so much.