R Ram Mher Member Aug 18, 2014 #1 Hi Everyone Good evening ! I want to look up the value after applying multiple conditions like Date,Type, Name and Nature. Refer the attachment and provide the solution if any. Attachments Sample for Lookup formula.xlsx Sample for Lookup formula.xlsx 12.2 KB · Views: 10
Hi Everyone Good evening ! I want to look up the value after applying multiple conditions like Date,Type, Name and Nature. Refer the attachment and provide the solution if any.
Mike H.. Active Member Aug 18, 2014 #2 Ram Mher said: Hi Everyone Good evening ! I want to look up the value after applying multiple conditions like Date,Type, Name and Nature. Refer the attachment and provide the solution if any. Click to expand... Hi, Not sure why some of column N are blanks but maybe this in N3 and drag down. =SUMPRODUCT(($A$3:$A$68=J3)*($B$3:$B$68=K3)*($C$3:$C$68=L3)*($D$3:$D$68=M3)*($E$3:$E$68))
Ram Mher said: Hi Everyone Good evening ! I want to look up the value after applying multiple conditions like Date,Type, Name and Nature. Refer the attachment and provide the solution if any. Click to expand... Hi, Not sure why some of column N are blanks but maybe this in N3 and drag down. =SUMPRODUCT(($A$3:$A$68=J3)*($B$3:$B$68=K3)*($C$3:$C$68=L3)*($D$3:$D$68=M3)*($E$3:$E$68))
