Results 1 to 6 of 6

Matching values in tables

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Zagreb
    MS-Off Ver
    2013
    Posts
    3

    Matching values in tables

    hi.

    i have 2 tables, TabA and TabB. i need to fill data in rows that meet certain conditions. if B3 in TabB equals range C:C in TabA, and D7 in TabB equals G:G in TabA than D8 in TabB should be filled. Row 8 in TabB equals H:H in TabA. So, for example:

    B3 is 150229 and M7 is 2015 / 10
    M8 should be 2.404.

    for N7 is 2015 / 11 N8 shoul be 7.409, etc.

    how do i acomplish this?

    tnx.
    Last edited by lobotomix; 09-16-2016 at 01:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Matching tables
    By mthappy0 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-17-2014, 07:01 AM
  2. [SOLVED] Matching two tables, copying data for matching value
    By Gatis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2014, 07:51 PM
  3. Matching Data's in the Tables
    By anwitha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2013, 02:17 AM
  4. Matching and Comparing two tables
    By chadman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2013, 10:20 AM
  5. SQL Query to get count of matching & non-matching data from two tables
    By Kiran2012 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 10:32 PM
  6. [SOLVED] Return cell values for non-matching & matching criteria
    By jenz_skallemose in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-13-2012, 11:52 AM
  7. matching rows from two tables
    By karleek in forum Excel General
    Replies: 5
    Last Post: 05-27-2009, 06:20 AM
  8. Replies: 13
    Last Post: 03-22-2007, 10:53 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