todays problem / listbox - max nested if's
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: todays problem / listbox - max nested if's

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

    Default

     
    I have a listbox with a source of 15 cells containing item numbers giving me 15 items in the box. When a certain item is selected in the box I need the other info about the item to appear in the cells to the right. So you pick item number "1" from the list box and the "pricing, cost, description, etc.." for item 1 show up in the cells to the right of the listbox. (the data for each item is listed on a seperate worksheet). Problem is I run out of nested if's at 7 so I can only make this happen with 7 of my 15 items!! My whole solution seems cumbersome with long if's in every cell that holds data. The if's determine the value in the "linked cell" of the listbox and show approiate item info based on the value. There has got to be a better way to do this! Please advise.. Thanks..

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,748
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    Try tp apply VLOOKUP.

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

    Default

    Can't seem to apply vlookup...

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

    Default

    any way to do this with a macro maybe?

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

    Default

    HELP!

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,748
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-05 07:46, keith wrote:
    Can't seem to apply vlookup...
    Did you create the list box using Toolbars|Forms? If so, what is its Cell link? And, What is its Selection type: Single, ...?

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

    Default

      
    Cell Link is K1
    I think I found a workaround with the CHOOSE function. I created a column (A) called "autonum" and put 1-15 in that column. Then made the source of the listbox 1-15. From there I used CHOOSE(k1, b2,b3,b4,b5,b6,b7 etc.. to b16) for the cell to the right of the listbox. B2-B16 is the "price" colum for the item.. not quite the same effect I wanted. I wanted to have the actual item numbers populate the listbox, but the autonum effect will work I guess.. Thanks for your help though..!

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
  •  

 

 
DMCA.com