+ Reply to Thread
Results 1 to 4 of 4

Vlookup/Lists Help

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    Dallas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Vlookup/Lists Help

    I'm working on updating our quoting tool for our company and I'm needing some help.

    I've incorporated our price sheets that show our cost based on each manufacturer. My columns include: Part Number, Description, Retail, Cost.

    The goal is to be able to look up a part number, then once that part number is selected it will then fill in the description, retail cost, our cost, etc. Sounds like a pretty simple VLookup.

    Vlookup works perfectly, however here are my issues:
    1) I have thousands of part numbers, a simple drop down list is WAY too long to scroll through to find each part number
    2) If we could start typing the part number then that could perhaps help. (I don't know how to do that)
    3) If I could potentially have a list before part numbers with the Manufacturers, then once the manufacturer is selected then have a 2nd list of only parts from that manufacturer. That would help, but would still like to begin typing the part number.

    TIA

    Attached are pics of the data sheet, and the 2nd is the quote. Part Number is the field I would like to select from the data.
    qte.JPGParts List.JPG

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: Vlookup/Lists Help

    Hi, you can combined an IF statement in data validation to get the result you want. Just a question though, how many parts are you looking at for a particular manufacturer?

  3. #3
    Registered User
    Join Date
    07-09-2013
    Location
    Dallas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Vlookup/Lists Help

    Lots! Depends on the Manufacturer, but several have thousands of part numbers. I'd say less than 10 Manufacturers though.

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Vlookup/Lists Help

    Post your sample workbook Bro... not JPEG File

+ 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