Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Match Columns from two sheets get results

    Hi All,
    Help to match two columns from Main sheet & Data sheet ( Columns A & B ) with formula and get the results in Main sheet based on Main sheet A & B Columns?
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Farrukh

    In cell M3 on worksheet Main, place the following formula then copy down:

    =SUMPRODUCT(Data!$C$3:$C$14*((Data!$A$3:$A$14=Main !A3)*(Data!$B$3:$B$14=Main!B3)))

    HTH,
    Maud

    Farukh.png

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    farrukh (2015-11-18)

  4. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi Maudibe,
    Many thanks for your help !
    Works great just little change required when there is no data ,formula shows nothing instead of zero value.
    I am attaching screenshot.
    Attached Images Attached Images

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Farrukh,

    Modify the formula in cell M3 to:

    =IF(OR(A3="",B3=""),"",SUMPRODUCT(Data!$C$3:$C$14* ((Data!$A$3:$A$14=Main!A3)*(Data!$B$3:$B$14=Main!B 3))))

    then copy down.

    HTH,
    Maud

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    farrukh (2015-11-18)

  7. #5
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi Maudibe,
    Many thanks for support & help. Working great.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •