Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 45
Default Linking Drop Down Box

I created a drop down box with 9 items. What I want to do is after the user
selects one of the 9 items, a price will show in the adjacent cell
corresponding to that chosen item.

I tried to use the IF function, but it works up to 8 items only. I used
if(A1=A3,B3,if(A1=A4,B4,if(A1=A5,B5,if(A1=A6,B6,if (A1=A7,B7,if(A1=A8,B8,0))))))

Is there any other method that I can use to accomplish this goal?
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Linking Drop Down Box

try:
=Vlookup(A1, A3:B10, 2, 0)


"Joey" wrote:

I created a drop down box with 9 items. What I want to do is after the user
selects one of the 9 items, a price will show in the adjacent cell
corresponding to that chosen item.

I tried to use the IF function, but it works up to 8 items only. I used
if(A1=A3,B3,if(A1=A4,B4,if(A1=A5,B5,if(A1=A6,B6,if (A1=A7,B7,if(A1=A8,B8,0))))))

Is there any other method that I can use to accomplish this goal?

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
Help With Linking Drop Down Boxes Vasu[_2_] Excel Discussion (Misc queries) 7 July 16th 08 08:19 PM
Linking Drop Down Boxes Vasu[_2_] Excel Discussion (Misc queries) 2 July 16th 08 03:13 PM
Linking Drop Down List Melissa McCracken Excel Worksheet Functions 3 February 13th 08 06:01 PM
Linking Drop-down options John1791 Excel Discussion (Misc queries) 1 October 5th 07 07:38 AM
Drop down list linking altah Excel Worksheet Functions 1 January 13th 07 01:45 AM


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

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"