Listbox Problem

Charlie · Mar 14th, 2002, 03:49 PM

I have a listbox on a worksheet,it is linked to an empty cell B16,the box itself has the input range Titles,this displays a list of book titles in the listbox.My problem is how do I make this box display when a book title is clicked, the cost price and the discount price.This information is on a seperate worksheet called Catalogue, the cells for the data are F2 Cost price and H2 for discount price.Corresponding values must be displayed for the various book titles.Index functions must be used to achieve the result, this has me completely stumped.

smozgur · Mar 18th, 2002, 05:56 AM

You know listbox returns the item order number of the item in data range when clicked. You can use this number with INDEX function to point selected item value in main data range.

If it would be difficult to understand by these words then please send me your xls to whow you how it could be done.

suat

Charlie · Mar 18th, 2002, 07:19 AM

Thankyou for replying, I managed to find the solution myself eventually, im sorry my message was not clearer, but I thought i put the question as clearly as I could, maybe when I learn more about excel I will be able to phrase things a little better, the solution I came up with is =INDEX(Discount_Price,B16,1)=INDEX(Cost_Price,B16,1)

smozgur · Mar 18th, 2002, 07:34 AM

Yes, it is the exact solution you have.

suat

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 03:49 PM	#1
Charlie Board Regular Join Date: Mar 2002 Posts: 134	I have a listbox on a worksheet,it is linked to an empty cell B16,the box itself has the input range Titles,this displays a list of book titles in the listbox.My problem is how do I make this box display when a book title is clicked, the cost price and the discount price.This information is on a seperate worksheet called Catalogue, the cells for the data are F2 Cost price and H2 for discount price.Corresponding values must be displayed for the various book titles.Index functions must be used to achieve the result, this has me completely stumped.

Mar 18th, 2002, 05:56 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	You know listbox returns the item order number of the item in data range when clicked. You can use this number with INDEX function to point selected item value in main data range. If it would be difficult to understand by these words then please send me your xls to whow you how it could be done. suat

Mar 18th, 2002, 07:19 AM	#3
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Thankyou for replying, I managed to find the solution myself eventually, im sorry my message was not clearer, but I thought i put the question as clearly as I could, maybe when I learn more about excel I will be able to phrase things a little better, the solution I came up with is =INDEX(Discount_Price,B16,1)=INDEX(Cost_Price,B16,1)

Mar 18th, 2002, 07:34 AM	#4
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Yes, it is the exact solution you have. suat