What function to use? Data Validation or IF

A

Allie B

I am trying to set up a spreadsheet that allows you to type text in cell A1
and it will automatically enter a dollar amount into cell B1. The text in A1
could be a number of options so a drop down box would be good to select from
but then how will this be able to place the corresponding dollar amount in B1.

eg. A1 - Sydney, LAX, Melbourne, London
B1 - 960, 10000, 1200, 15000

If you know an user friendly way of putting this information in, please help!

Thanks
Allie
 
B

Bob Phillips

Create a lookup table and use VLOOKUP in B1 based upon looking up the A1
value in that table. It's explained in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
Building a Pricing Model 2
Creating a Data Validation List based on a Value in another cell 2
Conditional data validation drop downs 2
Data Validation - Dependent List 1
Use Vlookup to store formulas? 6
Data validation- absolute ref or not- neither works 3
Data Validation used with VLookUp function 1

Top