+ Reply to Thread
Results 1 to 5 of 5

Create Connection Between Product # and Name

  1. #1
    Registered User
    Join Date
    07-13-2016
    Location
    NY
    MS-Off Ver
    365
    Posts
    2

    Create Connection Between Product # and Name

    Hello All,

    This is my first post and may be doing this incorrectly but I'm giving it a go anyways.

    I own a small business and sell over a product with over 500 variations. I previously would fill out invoices manually by typing each individual product number and name in their respective columns for billing. I am trying to find a way to enter the product number into it's respective column and have the product name appear automatically in it's respective column. I have a separate sheet with the numbers and names in columns, I think I am close but cannot tie it all together.

    I hope this isn't too confusing, any help would be greatly appreciated and save me tons of time and key strokes when billing!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,357

    Re: Create Connection Between Product # and Name

    You need to use either a VLOOKUP or an INDEX MATCH query.

    For example, in the invoice:

    =VLOOKUP(lookup_value,lookup_range,2,exact_match)

    The lookup_value will be the cell on the invoice where you type the number. The lookup_array will be the two columns on the other sheet with the numbers and names and 2 is the second column in that array, where the names are. The formula will go where you want the name to magically appear.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Create Connection Between Product # and Name

    you can use vlookup for this purpose. In Office 365
    =VLOOKUP(D1;$A$2:$B$11;2)
    IN WHICH RANGE D1 IS YOUR VALUE FOR SEARCH
    $A$2:$B$11 IS YOUR RANGE
    2 IS THE VALUE YOU WANT TO DISPLAY
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

  4. #4
    Registered User
    Join Date
    07-13-2016
    Location
    NY
    MS-Off Ver
    365
    Posts
    2

    Re: Create Connection Between Product # and Name

    Wow, you guys rock....Thank you!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,357

    Re: Create Connection Between Product # and Name

    No problem!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create one large database, and 30+ partial ones, with a two-way connection
    By treepio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2015, 09:55 AM
  2. Create a product order project
    By finditmax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2015, 01:21 PM
  3. Replies: 9
    Last Post: 10-16-2014, 07:46 AM
  4. Create Excel Function that Gets Data via ODBC Connection
    By Tyrone__ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 02:38 PM
  5. Macro to Create PowerPivot Connection
    By Ariff_Chowdhury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2013, 01:42 PM
  6. How to create a product configurator?
    By Arielis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2012, 08:21 AM
  7. [SOLVED] create a product calculator
    By exceloldiebutnewbie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-14-2006, 01:43 AM

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