Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 25th 08, 05:09 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1
Default What function to use? Data Validation or IF

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

  #2   Report Post  
Old June 25th 08, 08:10 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,594
Default What function to use? Data Validation or IF

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)

"Allie B" <Allie wrote in message
...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validating a name without using the Data Validation function twynsys Excel Worksheet Functions 3 November 29th 06 04:14 PM
data validation - indirect function Louise Excel Discussion (Misc queries) 1 November 8th 06 03:33 PM
Data Validation Function Help John Jost Excel Worksheet Functions 3 December 22nd 05 03:25 PM
DATA VALIDATION with LEFT function Gabe Excel Discussion (Misc queries) 2 May 6th 05 06:37 PM
Validation function under DATA Menu Asanny Excel Discussion (Misc queries) 2 March 16th 05 03:10 AM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017