Match Columns from two sheets get results

Topic

New Reply

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?

Reply | Quote

Replies

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

42652-Farukh

Reply | Quote

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.

Reply | Quote

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!B3))))

then copy down.

HTH,
Maud

Reply | Quote

Hi Maudibe,
Many thanks for support & help. Working great.

Reply | Quote