Listbox Problem

[Charlie]

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]

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]

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]

Yes, it is the exact solution you have.

suat