Building Estimation Spreadsheet

If

1) you can make your data on sheet 1 the way i made them

And

2) the cost are in the table on sheet 2

You can use index/match (see my example => the yellow cells).

I made it with text to collumn

CNTL H
find yrd
replace (leave empy)

do you have questions on this item, just ask.