+ Reply to Thread
Results 1 to 2 of 2

Match Values to Label Between 2 Tables with Tolerance

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Silicon Valley, CA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Match Values to Label Between 2 Tables with Tolerance

    I am looking to match values from Table 2 to Table 1 within a specified tolerance.

    For example:
    Table 1 has 3 columns:
    Label Value 1 (X) Value 2 (Y)
    Test_1 1 1
    Test_2 5 5


    Table 2 has only 2 columns:
    Value 1 (X) Value 2 (Y)
    4.7 5.3
    0.7 1.3


    Each table has the same amount of rows (for all intents and purposes).

    Table 1 has a label with the associated "perfect" values for each case. Table 2 has the experimental values for each case. However, the values in Table 2 will always be random and will not line up perfectly with the associated row in Table 1. Unlike Table 1, the values in Table 2 are also not perfect, but will be in a specified tolerance (in this case, +/- 0.3)

    I am then going to create a third table, Table 3, with the Labels in the same exact order as Table 1:

    Label Value 1 (X) Value 2 (Y)
    Test_1
    Test_2

    What I would like to do is take the imperfect values in Table 2, have it look at the perfect values in Table 1 (within a specified tolerance) with the associated label, and then spit it out to either Value 1 or 2. For example, I have measured a value of Value 1 = 0.7, and Value 2 = 1.3 (Table 2). I see that on Table 1, the closest value within a specified tolerance of +/- 0.3 are the values under Test_1, which is Value 1 = 1 and Value 2 = 1. In Table 3, it is going to associate the label with the values.

    Label Value 1 (X) Value 2 (Y)
    Test_1 0.7 1.3
    Test_2 4.7 5.3

    Would VLOOKUP be the proper method to do this?

    Thanks in advance

    EDIT: Added a small sample Excel file: question_sample.xlsx
    Last edited by hydronicengr; 07-20-2015 at 03:42 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Match Values to Label Between 2 Tables with Tolerance

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Look at multiple criterias to see if table values match values of other tables
    By gaudi93080 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2014, 06:45 PM
  2. [SOLVED] need values for tolerance
    By jlv7812 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-31-2014, 03:53 PM
  3. Align or Match data with a tolerance
    By vandana651 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 11:52 PM
  4. Align/match data with tolerance
    By vandana651 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2013, 06:34 PM
  5. [SOLVED] Match text values between two tables
    By awsz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-10-2013, 07:41 AM
  6. Checking a tolerance with two values
    By noobsaibot in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2013, 06:02 PM
  7. match values between tables
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2010, 12:25 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