# Automating a worksheet

#### petice

##### Board Regular
After spending \$40 on an Excel Bible I still can't figure out how to automate my worksheet.
Column A has 5 different items I can select from a pick list.
Column B needs to have the dollar amount charged depending on which item I've selected.
Basic is \$29.95
Standard is \$49.00 and so on and so forth.

How the heck do I do that. This expensive book tells doesn't tell me diddly and I'm ready to scream.

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Juan Pablo González

##### MrExcel MVP
You need to use, first, Data | Validation to set up the list to choose from.

Then, in the cell next to it (Or somewhere where you want it), use the VLOOKUP formula to lookup the user's choice in this list, in your "prices" list.

#### maxflia10

##### Well-known Member
The first questions deals with Data Validation and creating a list. Highlight the list and name your list. Go to Data/ Validation/in the allow window, select list and in the source window enter =listname (or whatever you named your list).

The second question deals with VLOOKUP.

=VLOOKUP(A1,RANGE,2,0)

Where A1 is the cell your list from the data validation is,
Range is the two column range of the validation list and price
2 is the column you want to extract info from
0 is looking for an exact match

#### gplhl

##### Board Regular
Use either VLOOKUP to find the relative information from another sheet or hardcode it in using

IF(A1 = "BASIC",29.95,IF(A1 = "STANDARD", 49.95, and so on

#### petice

##### Board Regular
I don't understand how to use functions and nothing in the book explains HOW to do it.
It only explains that you CAN do it. When the function wizard displays am I selecting cells or typing in the word or what?
I need baby steps on how to actually do it.

Replies
4
Views
269
Replies
8
Views
1K
Replies
4
Views
271
Replies
5
Views
806
Replies
6
Views
553

1,182,137
Messages
5,933,854
Members
436,915
Latest member
Cygne volant

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back