Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Listbox Problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    813
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)

  4. #4
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    813
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, it is the exact solution you have.

    suat

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •