Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Evening all

    I am having a dumb moment (nothing new there then).

    I have a Combo box linked to cell B3 (the information is on a sheet names Accounts $A$3:$A$200)
    In B4, B5, B6 and B7 I want to show the information from Accounts A4:A200, A5:A200, A6:A200 and A7:200 when a particular account is selected in the combo.

    I have tried using a VLOOKUP formula with any luck. Any poiners gratefully received

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='VegasNath' post='767113' date='24-Mar-2009 21:00']Steve, would you post a small sample? tx.[/quote]

    Hi Nathan

    Thanks for taking a look
    Attached Files Attached Files
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Like this?[attachment=83033:steve.xls]
    Attached Files Attached Files

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='VegasNath' post='767122' date='24-Mar-2009 21:28']Like this?[attachment=83033:steve.xls][/quote]
    Hi Nathan

    Thanks for that but I stll have a problem, I have changed the addresses in the example so I can see if they are changing but something weird is happening, i I choose Company 2 it shows the address for Company 19. Sorry it is probably me being dense because I am trying to hurry.
    Attached Files Attached Files
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  6. #6
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry, less speed, more haste!!

    Add ",FALSE" inside the end bracket for each:

    =VLOOKUP($B$3,Addresses!$A$3:$E$25,2,FALSE)

    and for 3, 4 & 5 in the same way.

  7. #7
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Cheers Nathan

    Worked perrfectly

    Ta

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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