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.

Are you using a data validation drop down or a combo box?

"TMBS P.M." wrote:

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.

Data validation

"akphidelt" wrote:

Are you using a data validation drop down or a combo box?

"TMBS P.M." wrote:

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.

Alright, you can use a vlookup for that. Assume your data validation drop
down starts in cell A1.

In cell B1 put in the formula

=Vlookup(A1,Sheet1!I1:H1000,2)

Change H1000 to however long your data set is

"TMBS P.M." wrote:

Data validation

"akphidelt" wrote:

Are you using a data validation drop down or a combo box?

"TMBS P.M." wrote:

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.