Re: $$Excel-Macros$$ need required for data validation value query

2011-07-04 Thread ankur
Main Sheet with each > other. > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Monday, July 04, 2011 2:06 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ need required fo

RE: $$Excel-Macros$$ need required for data validation value query

2011-07-04 Thread Rajan_Verma
t; >> >> On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma wrote: >>> See if it helps >>> >>> -Original Message----- >>> From: excel-macros@googlegroups.com >>> [mailto:excel-macros@googlegroups.com] >>> On Behalf Of ankur >>>

RE: $$Excel-Macros$$ need required for data validation value query

2011-07-04 Thread Rajan_Verma
> -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Friday, July 01, 2011 5:17 PM > To: excel-macros > Subject: Re: $$Excel-Macros$$ need required for data validation value query > > sorry ,

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-04 Thread ankur
PM, Rajan_Verma wrote: >>> See if it helps >>> >>> -----Original Message- >>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >>> On Behalf Of ankur >>> Sent: Friday, July 01, 2011 5:17 PM >>> To: excel-macro

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-03 Thread ankur
> -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of ankur > Sent: Friday, July 01, 2011 5:17 PM > To: excel-macros > Subject: Re: $$Excel-Macros$$ need required for data validation value query > > sorry ,

RE: $$Excel-Macros$$ need required for data validation value query

2011-07-02 Thread Rajan_Verma
See if it helps -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Friday, July 01, 2011 5:17 PM To: excel-macros Subject: Re: $$Excel-Macros$$ need required for data validation value query sorry , i forget to attach a

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-01 Thread ankur
hi rakesh thnks for reply this is not a simple vlookup formula case, i just want to get figure by changing validation list..because calculation is having many backhand formulas... well... i want you tell that...this income tax calculation sheet sample.the result which is showing is net inco

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-01 Thread ICWAI Help
Please find the attached file. Thanks, Rakesh. On Fri, Jul 1, 2011 at 5:49 PM, Markkim wrote: > I'm not sure if I understand what you want correctly. > > > O2 cell in your sample file > > you can have the following formula > > =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) > > t

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-01 Thread Markkim
I'm not sure if I understand what you want correctly. O2 cell in your sample file you can have the following formula =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) then do autofill .. Is this what you want? -- -

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-01 Thread ankur
sorry , i forget to attach a sample file in my query.. Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jul 1, 2011 at 5:14 PM, ankur wrote: > hi ayush/ all members > >  i have one data validation list, which is r