LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default referencing drop down menu values in IF-then statements?

I'm trying to use a drop down list to automatically input numbers into two
other cells.

eg

Drop-down menu Price 1 Price 2

what I'd like do is have it so that once I choose an item from the drop down
menu the cells of Price 1 and Price 2 woudl be automatically filled with the
proper number.

any suggestions???

Mike
 
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
IF statements referencing an absolute value or a range of values skaminski Excel Worksheet Functions 6 April 4th 23 12:45 PM
Pull Down Menu referencing to another page Damdog Excel Discussion (Misc queries) 1 February 3rd 08 08:43 PM
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM
How to create a drop down menu which referencing a different workb Joanne Excel Discussion (Misc queries) 1 June 18th 05 11:51 AM


All times are GMT +1. The time now is 06:05 PM.

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

About Us

"It's about Microsoft Excel"