Can this be done?

A

Anita

I have worksheets for building surveys I've created. I'm trying to make a
column where I choose and Action to be done represented by "A" clean "B"
paint "C" repair "D" Replace. I would like this to be a dropdown menu. Then I
have a column that represent the Cost for the action which I have on another
worksheet. Is it possible to have it look at my Action column and choose the
correct Cost from my other worksheet?

Thanks in advance for any help.
 
G

Gary's Student

This is just an example, you may have to use different columns.

Let's assume that the drop-down codes are in column A.
Let's assume that the associated costs are in column B.

First enter A,B,C,D in sequential cells in column D.
Then format all the cells in column A as text.
Select column A and Data > Validation.. >
Select List from the Allow dropdown. Next click on the source field and
select the four cells in column D. Also make sure that the In-cell dropdown
is checked and click OK.

The above results in a dropdown for each cell in column A.

In column B, enter a VLOOkUP formula that supplies the cost associated with
each code.
 
K

Ken Hudson

Anita,
Assuming that:

1. Entries in column A in Sheet1 are A, B, C, or D.

2. In Sheet2 you have the following:

A B
1 A $100
2 B $200
3 C $300
4 D $400

In cell B1 on Sheet1 you enter the following:

=VLOOKUP(A1,Sheet2!$A$1:$B$4,2,FALSE)

You will get the corresponding cost for the letter selected in cell A1.

Copy this formula down the appropriate rows in column B.

HTH
 
Top