+ Reply to Thread
Results 1 to 2 of 2

Match one column data with data in the second column

  1. #1
    Registered User
    Join Date
    10-27-2021
    Location
    Canada
    MS-Off Ver
    365
    Posts
    22

    Match one column data with data in the second column

    I don't know if this can be done but I have a table with columns named Manager, Employee, EmpNum.

    In a form created from the table, I have a 2 dropboxes, Manager and Employee.

    How do I auto-populate a textbox with the EmpNum of the name chosen from the Employee dropbox?

    It would be the same as a Vlookup in Excel.
    Last edited by imonline; 03-22-2023 at 07:21 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2310 Win 11 Home 64 Bit
    Posts
    23,135

    Re: Match one column data with data in the second column

    If you are using a Form and that form is bound to your table then the relationship is already there and the text box on the form should automatically populate once you put in either the Manager or the Employee.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] match between two sheets baesd on column and copy whole data and insert column(costing)
    By leap out in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-22-2021, 02:49 PM
  2. [SOLVED] Match data in 1 column and count unique data in another column based on matches
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2020, 12:31 PM
  3. [SOLVED] Compare 1 column with another column and match data in next column
    By screambeam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2015, 02:49 AM
  4. Copy data from column K to column B if Column C and column I match
    By goog2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2013, 12:19 PM
  5. Replies: 9
    Last Post: 07-22-2012, 12:03 PM
  6. Replies: 1
    Last Post: 05-06-2011, 03:08 AM
  7. Replies: 2
    Last Post: 03-16-2009, 12:26 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