Hi,
Use this..
=INDEX(Sheet1!$D$2:$D$18,MATCH(Sheet2!A2,Sheet1!$B$2:$B$18))
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 7:02 PM, Rajan_Verma wrote:
> *=SUMPRODUCT(N(Sheet1!$B$2:$B$18=Sheet2!A2),Sheet1!D2:D18)*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
=SUMPRODUCT(N(Sheet1!$B$2:$B$18=Sheet2!A2),Sheet1!D2:D18)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 03 September 2012 1:01
To: excel-macros@googlegroups.com
Subject: $$
Hi Rakesh,
Please try this.
=INDEX($D$5:$D$21,MATCH(K4,$B$5:$B$21))
Ctrl + Shift + Enter
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 1:24 PM, Rakesh Kumar Sharma
wrote:
> Dear Manoj,
>
> I have to pick actual remit amt with vlookup or any other formula. Amt is
> remitted for same tracking i
Dear Manoj,
I have to pick actual remit amt with vlookup or any other formula. Amt is
remitted for same tracking in month of apr is 100, may -250, june 150 then
when i use vlookup for this tracking should give remitted amt=0
becoz amt will be (+100-250+150)=0
On Mon, Sep 3, 2012 at 1:07 PM, Ma
Dear Rakesh,
Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)*
Regd
Manoj
On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma
wrote:
> Hi Experts,
>
> I need the actual remit amt agnst tracking on sheet2 when data was found
> repeated on sheet1 with positive or nigative amt.
> See the att
