Automating a worksheet

petice

Board Regular
Joined
May 14, 2002
Messages
74
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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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
Joined
May 20, 2002
Messages
890
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
Joined
Feb 23, 2002
Messages
150
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
Joined
May 14, 2002
Messages
74
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.
 

Forum statistics

Threads
1,143,709
Messages
5,720,391
Members
422,283
Latest member
Parvathy

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top