+ Reply to Thread
Results 1 to 3 of 3

2 different sheet matched and multiply if same

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    2 different sheet matched and multiply if same

    Hi,
    I have got 2 Sheets, Sheet1 and Sheet2

    Sheet1
    A1 B1 C1 D1
    A2 B2 C2 D2
    A3 B3 C3 D3
    A4 B4 C4 D4
    A5 B5 C5 D5

    Sheet2
    A1 B1 C1
    A2 B2 C2
    A3 B3 C3
    A4 B4 C4
    A5 B5 C5

    If the Cell Values of A1 AND B1 from Sheet1, matches with Cell Values of A1 AND B1 from Sheet2, then MULTIPLY C1 (Sheet1) with C1 (Sheet2). Now Display the result in D1 (Sheet1).

    Thank you,
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,923

    Re: 2 different sheet matched and multiply if same

    In D1, =IF(AND(A1=Sheet2!A1,Sheet1!B1=Sheet2!B1),Sheet1!C1*Sheet2!C1,"does not match") and copy down.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: 2 different sheet matched and multiply if same

    Thank You Alan for your kind help.

+ 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. Matched 2 sets of coluumns then multiply 2 others
    By skell1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-09-2015, 12:16 AM
  2. Getting value from the main data sheet if name matched
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2015, 04:11 PM
  3. Replies: 11
    Last Post: 03-27-2014, 07:55 PM
  4. Multiply cells in two worksheets conidtion is matched and use of looping
    By tsiddiq23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2013, 01:55 AM
  5. Return row of data to a another sheet where a value is matched
    By adambriggs in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2013, 10:41 AM
  6. [SOLVED] Copy non-matched row to different sheet
    By tink_ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2012, 08:25 PM
  7. Matched column in a new sheet
    By iamreese in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 11-15-2011, 01:30 AM

Tags for this Thread

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