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

2011-07-04 Thread ankur
: 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 sample file in my query.. Have A Nice Time

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

2011-07-04 Thread ankur
Subject: Re: $$Excel-Macros$$ need required for data validation value query 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

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

2011-07-04 Thread Rajan_Verma
: 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 sample file in my query.. Have A Nice Time

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

2011-07-04 Thread Rajan_Verma
: 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 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

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

2011-07-04 Thread ankur
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 for data validation value query

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

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

2011-07-01 Thread ankur
hi ayush/ all members i have one data validation list, which is required in formula to get a result i want the all results corresponding to each value in different sheet or in different column in one click any macro code is there ? thanks in advance Have A Nice Time Enjoy Life

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 ankurpande...@gmail.com wrote: hi ayush/ all members  i have one data

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 ICWAI Help
Please find the attached file. Thanks, Rakesh. On Fri, Jul 1, 2011 at 5:49 PM, Markkim mark@gmail.com 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) *

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