I am setting up an estemating spread sheet. Sheet 1 has all my drop down list
info on it and sheet 2 is the estemating list. I am trying to set up my
estemating sheet so when I pick an item on the material drop down list, the
price will list in the next cell. For example, sheet 1 H1 reads lap siding.
Sheet 1 I1 reads $1.00 . When I pick the drop down list on sheet 2 for
siding and I pick Lap siding, I need the price to change when the item is
picked.