+ Reply to Thread
Results 1 to 6 of 6

Match across a row in a table

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    53

    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
    Forum Contributor
    Join Date
    02-06-2014
    Location
    Jesus is Lord
    MS-Off Ver
    Excel 2013
    Posts
    282

    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.
    John 14:6 KJV "Jesus saith unto him, I am the way, the truth, and the life: no man cometh unto the Father, but by me."

  3. #3
    Registered User
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    53

    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
    Forum Contributor
    Join Date
    02-06-2014
    Location
    Jesus is Lord
    MS-Off Ver
    Excel 2013
    Posts
    282

    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
    Registered User
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    53

    Re: Match across a row in a table

    Cool. Thanks for your help.

  6. #6
    Forum Contributor
    Join Date
    02-06-2014
    Location
    Jesus is Lord
    MS-Off Ver
    Excel 2013
    Posts
    282

    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)

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