Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread Jagadeesh B S
e a bit but not able to do well as per my >> requirement. Could you please look it to the attachment and help me >> again...? >> >> Thanks for your valuable assistance. >> >> Thanks >> Jagadeesh B S >> >> >> >> On Wed, Nov 17, 2010 at 6:56 P

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread Ajay Varshney
x the values with "Z" (or some alpha character) > > Paul > > > *From:* Jagadeesh B S > *To:* excel-macros@googlegroups.com > *Sent:* Thu, November 18, 2010 1:18:24 AM > *Subject:* Re: $$Excel-Macros$$ Help required for formule > > > Hello friends my require

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread Paul Schreiner
h "Z" (or some alpha character) Paul > >From: Jagadeesh B S >To: excel-macros@googlegroups.com >Sent: Thu, November 18, 2010 1:18:24 AM >Subject: Re: $$Excel-Macros$$ Help required for formule > > > > >Hello friends my requirement is met in some way but not the compl

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread OpenExcel.com
gt; *From:* Jagadeesh B S > > *To:* excel-macros@googlegroups.com > > *Sent:* Wed, November 17, 2010 7:45:42 AM > > *Subject:* $$Excel-Macros$$ Help required for formule > > >  Hello Friends > > > I need a formula or macro( preferabley formule) need to prepare this repo

Re: $$Excel-Macros$$ Help required for formule

2010-11-17 Thread Paul Schreiner
Your formula for row 3 would look like: =IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE)) Paul > >From: Jagadeesh B S >To: excel-macros@googlegroups.com >Sent: Wed, November 17, 2010 7:45:42 AM >Subject: $$Excel-Macros$$ Help required for form

$$Excel-Macros$$ Help required for formule

2010-11-17 Thread Jagadeesh B S
Hello Friends I need a formula or macro( preferabley formule) need to prepare this report . I need a formula which should get the details for the account # mentioned in the column A with the reference to the currency,form the sheet DATA, if the currency is USD It should pull the value in the colu