Results 1 to 7 of 7

lookup multiple cells with corresponding multiple criteria based on one table

Threaded View

  1. #1
    Registered User
    Join Date
    12-12-2018
    Location
    israel
    MS-Off Ver
    2010
    Posts
    3

    lookup multiple cells with corresponding multiple criteria based on one table

    Hello,
    I've been trying to find an answer to this question online - so far no success.
    I have a table of several types, where each type has two values (Z1,Z2)
    I have another table, with 6 rows, in each row several instances of the types from the first table, with no specific order.
    I'm trying to calculate the TOTAL Z1 and Z2 values of all the instances in each row.

    Any idea?

    Thank you alllookup table.jpg
    Attached Files Attached Files
    Last edited by eligt; 12-12-2018 at 04:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup based on Multiple Criteria on Multiple Table
    By oktovan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2017, 04:04 PM
  2. SUM multiple cells based on multiple cell criteria,not a range
    By georgiepod in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-01-2015, 01:10 PM
  3. Replies: 9
    Last Post: 08-20-2014, 04:43 PM
  4. Populating fields in multiple cells based on criteria in multiple columns
    By excelalways in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2014, 08:17 AM
  5. [SOLVED] Lookup and sum multiple values based on a single criteria in multiple sheets.
    By paulsanett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 12:18 PM
  6. [SOLVED] VBA fill in cells in a new column in table based on multiple criteria from other columns
    By HRA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2013, 06:48 AM
  7. Replies: 1
    Last Post: 11-20-2010, 05:38 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