Double Criteria in Excel

Replies to This Discussion

Permalink Reply by lilolee on February 28, 2010 at 4:35am

Attached is my answer

Attachments:

• Copy of Productcheck.xls, 21 KB

▶ Reply to This

Permalink Reply by Sachin karnik on February 28, 2010 at 5:08am

This could also be done in following way.

Attachments:

• Soultion Productcheck.xls, 20 KB

▶ Reply to This

Permalink Reply by Muhammad Majid on March 7, 2010 at 11:39am

Hello Sir,

You have solved my problem in past, sir i want to request you to solve again my problem. I am sending you again my double criteria file. if H1 cell and H2 cell will match the list of give product and sizes then H5 cell pickup weight automatically from the given list then multiply with I1 cell for true condition otherwise multiply with j1 cell for false condition.
this is if then criteria.

thanks

Attachments:

• SoultionProductcheck.xls, 26 KB

▶ Reply to This

Permalink Reply by Ankit Arora on March 17, 2010 at 4:46am

Well you can even use this instead of Arraying the Index fn

= SUMPRODUCT((B3:B27 = H1)*1, (C3:C27 = H2)*1, D3:D27)

Thanks,
Ankit

▶ Reply to This

Permalink Reply by Sachin karnik on March 17, 2010 at 11:06pm

I hope you wanted this.....

Check if i have understood your query.

Attachments:

• SoultionProductcheck.xls, 21 KB

▶ Reply to This

Permalink Reply by Muhammad Majid on March 25, 2010 at 1:44pm

Thanks Sir,

You solved my problem.

Majid Siddique

▶ Reply to This