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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

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
Back
Top