In addition to the below post, you cannot use Sumproduct to get the Text
Data as result.
<><><><><><><>
*Ms-Exl-Learner*
<><><><><><><>
On 10-10-2012 11:13 PM, Kuldeep Singh wrote:
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Sing
Dear Shrinivas,
You can try it..
With Additional column it is possible through vlookup
=VLOOKUP(CONCATENATE(H3,I3,J3,K3),$A$2:$F$5,6,0)
Or
=INDEX($E$2:$E$5,MATCH(1,($A$2:$A$5=G3)*($B$2:$B$5=H3)*($C$2:$C$5=I3)*($D$2:$D$5=J3),0))
with cse
or
=LOOKUP(9E+300,1/(($A$2:$A$5=$G$3)*($B$2:$B$5=$H$3)*
Thanks to all
Great Help
Thanks once again
Regards
Shrinivas
On Wed, Oct 10, 2012 at 11:13 PM, Kuldeep Singh wrote:
>
> Hi Srinivas,
>
> Please use this.
>
> =SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
>
> Regards,
> Kuldeep Singh
>
>
> On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginn
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Shrini,
>
>Find the Attachment.
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
>
Hi Shrini,
Find the Attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks
Hi Shrini,
Please share a sample worksheet.
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks in advance
>
> -
Dear All
Is it possible to use Vlookup with multple conditio. i e.
Can I get the value From Column E if All the column a,b,c,d matches.
Thanks in advance
--
Shrini
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
