+ Reply to Thread
Results 1 to 2 of 2

Checking data between Table 1 and Table 2.......what is the easiest way?

  1. #1
    Registered User
    Join Date
    03-18-2024
    Location
    London
    MS-Off Ver
    365
    Posts
    2

    Checking data between Table 1 and Table 2.......what is the easiest way?

    Hello,

    I need to use Table 1 to check the values that have been entered in Table 2 to make sure the values have been entered correctly.

    What is the easiest way of doing this? Is there a formula to do this?

    I have attached the spreadsheet onto this post.

    Please note, I have purposely entered some incorrect values in Table 2 to check if the method or formula used will work.

    Thanks
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Checking data between Table 1 and Table 2.......what is the easiest way?

    Table 1 has all the information necessary to make Table 2. Why enter the data twice? Use formulas to generate Table 2. See sheet Solution.

    P.S. do not use merged cells
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Checking if data already exists in table
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2019, 09:54 AM
  2. [SOLVED] How can I replace Name in Table 1 from Table 2 by easiest way?
    By Indra Rai in forum Excel General
    Replies: 8
    Last Post: 04-03-2017, 12:23 AM
  3. Checking Range, altering out of bounds, checking result against table
    By Sillystring in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-11-2016, 06:47 AM
  4. Replies: 2
    Last Post: 07-16-2015, 07:17 PM
  5. Replies: 1
    Last Post: 09-18-2012, 04:10 PM
  6. Replies: 0
    Last Post: 05-21-2012, 04:03 AM
  7. Checking that a name from a Table 1 has the same spelling than another data set
    By Laeticha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 11:39 AM

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