+ Reply to Thread
Results 1 to 5 of 5
  1. 04-05-2009, 06:28 PM #1
    P357
    P357 is offline
    Registered User
    Join Date
    08-28-2008
    Location
    up north
    Posts
    26

    Drop down list for 2 cells

    I have a form with 2 columns. in the 1st, we have the product and in the 2nd, we have the price.

    I have my drop down list for column1 but I want column 2 to show the correct price when column 1 has a product.

    My data is side by side already. How can i tell column 2 to show the correct price?
    Last edited by P357; 04-05-2009 at 08:02 PM.
    Reply With Quote Reply With Quote
  2. 04-05-2009, 06:41 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Guru VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    12,009

    Re: Drop down list for 2 cells

    Try Vlookup as explained in link

    http://www.contextures.com/xlFunctions02.html

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With Quote Reply With Quote
  3. 04-05-2009, 07:39 PM #3
    P357
    P357 is offline
    Registered User
    Join Date
    08-28-2008
    Location
    up north
    Posts
    26

    Re: Drop down list for 2 cells

    OK, i tried using the tutorials shown but it seems to limit my choices to like 5 or 6... after that, it fails.
    Reply With Quote Reply With Quote
  4. 04-05-2009, 07:40 PM #4
    P357
    P357 is offline
    Registered User
    Join Date
    08-28-2008
    Location
    up north
    Posts
    26

    Re: Drop down list for 2 cells

    to be exact, 6.
    Reply With Quote Reply With Quote
  5. 04-05-2009, 08:02 PM #5
    P357
    P357 is offline
    Registered User
    Join Date
    08-28-2008
    Location
    up north
    Posts
    26

    Re: Drop down list for 2 cells

    I used a False to keep the cell exact and it solved my problem. Thank you VBAnoob for your help!!! Very good tips!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0