+ Reply to Thread
Results 1 to 2 of 2

Validation List needs to return ID from selected Name

  1. #1
    Registered User
    Join Date
    12-06-2017
    Location
    California, USA
    MS-Off Ver
    2013
    Posts
    1

    Validation List needs to return ID from selected Name

    Is it possible to have an ID returned when selecting a Name?

    I have a workbook where sheet 1 is a form used to load data into a database. One of the columns on the form is Company ID. Sheet 2 has a table with Company ID (column A) and Company Name (column B). I am trying to get a data validation list where users can find and select the appropriate Company Name but the field is actually populated with the Company ID.

    Any help or suggestions is greatly appreciated.

    Norm

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Validation List needs to return ID from selected Name

    can with index and match functions


    Kind regards
    Leo

+ 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. [SOLVED] Active X drop down list - always return to the item in the list that was selected.
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2017, 09:41 AM
  2. [SOLVED] Auto update of indirect list when parent validation list is re-selected.
    By xtremca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-23-2015, 10:15 AM
  3. Remove an item from a validation list after selected?
    By hey_ray in forum Excel General
    Replies: 6
    Last Post: 02-23-2014, 05:18 PM
  4. How can I get the selected value of a data validation list with vba?
    By nikko50 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2014, 04:29 PM
  5. Validation List to Show when the cell is selected
    By Vinodv in forum Excel General
    Replies: 0
    Last Post: 07-30-2013, 05:04 AM
  6. data selected by validation 2 list
    By pichai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2008, 08:39 AM
  7. how to monitor the selected value of a Data Validation list
    By silkworm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2005, 12:10 PM

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