+ Reply to Thread
Results 1 to 6 of 6

Match across a row in a table

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    101

    Match across a row in a table

    I have a TextBox (TextBox7) in a UserForm (START_A_JOB) that people input there initials into. When they click a button i would like to refer to a Table (Table3) on Sheet (AVAILABILITY) to check that they don't already have a job open.
    Below is a capture of the table and the code that i am currently using witch works fine, but i would like to simplify the code and make it so that if a new person joins of if someone leaves then i just have to edit the table instead of editing the code.

    On the table the Open Job and Total Job columns are automatically updated and also works fine.

    Capture.JPG

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Match across a row in a table

    Use a vlookup function to return the value in col H for the row matching your textbox value in col C

    Something like this...

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    101

    Re: Match across a row in a table

    Thanks for the reply.
    Do i not need to refer to the table columns directly, C: is the ("INITIALS") column & H: is the ("OPEN JOBS") column in Table3.

  4. #4
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Match across a row in a table

    You can, but you don't need to, as long as the position of those columns won't change.

  5. #5
    Forum Contributor
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    101

    Re: Match across a row in a table

    Cool. Thanks for your help.

  6. #6
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Match across a row in a table

    No worries, glad to help

+ 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] Index Match Match for a small table lookup
    By slvrbktom in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-05-2018, 06:08 PM
  2. Replies: 3
    Last Post: 06-03-2018, 01:23 AM
  3. [SOLVED] Table lookup for exact match and match between range
    By chris4mayor in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-16-2018, 05:54 PM
  4. [SOLVED] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  5. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  6. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  7. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 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