Drop down list to enter information in the workbook

[Guest]

I am trying to develop an estimating spreadsheet for my company. I would
like to create drop down lists that have multiple cells of information tied
to them.

For example if the user selects 20 cubic yard dumpster from the drop down
list, the cost of the dumpster, a description of it, and labor are all
automatically put into the estimate. I have found ways to tie one cell to a
drop down list, but I am having trouble tying an entire row of both text and
numbers. Thank you very much for the help.

 

[Dave Peterson]

You could set up a table on another sheet (hidden???) and then use the first
column of that table as the source for the dropdown (are you using
data|validation for that dropdown?)...

Then you could use formulas to return the other values.

If the cell with the data|validation is A1:

=if(a1="","",vlookup(a1,sheet2!a:e,2,false))
to retrieve the value in column B (for the matching value in the table).

Debra Dalgleish has notes:
http://www.contextures.com/xlFunctions02.html

 

[Guest]

Thanks, I got it now.

You could set up a table on another sheet (hidden???) and then use the first
column of that table as the source for the dropdown (are you using
data|validation for that dropdown?)...

Then you could use formulas to return the other values.

If the cell with the data|validation is A1:

=if(a1="","",vlookup(a1,sheet2!a:e,2,false))
to retrieve the value in column B (for the matching value in the table).

Debra Dalgleish has notes:
http://www.contextures.com/xlFunctions02.html