Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-07-04 Thread dguillett1
@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP Hi Rajan Get Total function (UDF) is perfectly fine, but it is taking too much time to process large data. Is there any other way to get the same results using Excel in-built functions like VLOOKUP/ SUMPRODUCT/ INDIRECT. I

Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-24 Thread Amit Gandhi
]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi > *Sent:* 23 June 2012 5:19 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP > > ** **

RE: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-23 Thread Rajan_Verma
2012 5:19 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP Thanks Mr. Rajan For given set of values, its working perfectly. But I have some questions. 1. If values in H5:H9 are changed, then it doesn't give correct result. Pls su

Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-23 Thread Amit Gandhi
* > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi > *Sent:* 22 June 2012 5:20 > *To:* excel-macros@googlegroups.com > *Sub

RE: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-23 Thread Rajan_Verma
ups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Gandhi Sent: 22 June 2012 5:20 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP Hi Experts I have two Input/Lookup tables, and 1 result table. I want a formula which can give me desired resu

Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-22 Thread Amit Gandhi
com] *On Behalf Of *Amit Gandhi > *Sent:* 22 June 2012 5:20 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP > > ** ** > > Hi Experts > > ** ** > > I have two Input/Lookup tables, and 1 result table.

RE: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-22 Thread Rajan_Verma
: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP Hi Experts I have two Input/Lookup tables, and 1 result table. I want a formula which can give me desired result instantly. Sample file is attached for your ready reference. How it will be possible? Pls help me here. Regards Amit

$$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP

2012-06-22 Thread Amit Gandhi
Hi Experts I have two Input/Lookup tables, and 1 result table. I want a formula which can give me desired result instantly. Sample file is attached for your ready reference. How it will be possible? Pls help me here. Regards Amit -- -- FORUM RULES (986+ members already BANNED for violation)