+ Reply to Thread
Results 1 to 2 of 2

Drop Down Box with auto-fill on other cells

  1. #1
    Registered User
    Join Date
    09-27-2007
    Location
    Staten Island, NY
    MS-Off Ver
    Office 2013
    Posts
    64

    Smile Drop Down Box with auto-fill on other cells

    Heres what I need to do, hope this is clear enough:
    I have 2 sheets, 1 and 2 (duh)
    On sheet 1, I have a list of products set up (There will be about 300).
    Column A has the name and columns B and C have my price and selling price respectively.

    On sheet 2, I want to be able to type in a customer name in column A, then have a pull down list in B next to the name of all the products. I got that working so far. The problem is when I pick a product in the pull down box, I want my price and selling price from Sheet 1 to fill in on sheet 2 Column C and D respectively.

    If this is confusing, I try to explain a little better or upload a sample. Thanks in advance for all the help!!

  2. #2
    Registered User
    Join Date
    09-27-2007
    Location
    Staten Island, NY
    MS-Off Ver
    Office 2013
    Posts
    64
    Woohoo! I was reading some other threads and found the VLOOKUP function and it did the trick!!!
    I apologize I posted a thread with the answer out there already.

    Feel free to delete this and thanks!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1