Creating a form
Results 1 to 3 of 3

Thread: Creating a form

  1. #1
    New Member
    Join Date
    Dec 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Creating a form

     
    I have a worksheet that has a field allowing for a user to enter a part #. However, I would like for a description of the item to appear in the adjacent cell once the user enters a code. Example of my master list:


    Part # Description
    1 hammer
    2 screwdriver
    3 wrench
    4 tape

    If you can assist me with this I would greatly appreciate it

  2. #2
    Board Regular ranman256's Avatar
    Join Date
    Jun 2014
    Location
    Kentucky
    Posts
    1,557
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a form

    VLOOKUP( value, table, index_number)

    value = cell of part#
    table = range of inventory:
    A1:B6
    index_number = return column

    VLOOKUP(a2, Y1:Z6, 2) lookup part# in cell A2, in table Y1:Z6, return what is in column 2
    Last edited by ranman256; Dec 7th, 2017 at 01:25 PM.

  3. #3
    New Member
    Join Date
    Dec 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a form

      
    Thanks!

    Will VLookup also allow for me enter a default message like, "Enter a part # in the box to the left"?

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com