Re: $$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

2012-06-08 Thread Mangesh Dayne
Thanks All !!! On Fri, Jun 8, 2012 at 3:27 PM, Anoop K Sharma wrote: > Follow Noorain's method... > > > On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI > wrote: > >> Yes, Sure Vivek it is possible.. >> Please use >> >> =vlookup(Lookup value,Index File refernce,File No.,0) >> >> it will better i

Re: $$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

2012-06-08 Thread Anoop K Sharma
Follow Noorain's method... On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI wrote: > Yes, Sure Vivek it is possible.. > Please use > > =vlookup(Lookup value,Index File refernce,File No.,0) > > it will better if you share a sample workbook with group > > > > On Fri, Jun 8, 2012 at 10:12 AM, vivek

Re: $$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

2012-06-07 Thread NOORAIN ANSARI
Yes, Sure Vivek it is possible.. Please use =vlookup(Lookup value,Index File refernce,File No.,0) it will better if you share a sample workbook with group On Fri, Jun 8, 2012 at 10:12 AM, vivek wrote: > I have created a file index , with separate sheets alphabetically. > > ** ** > > Now I

Re: $$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

2012-06-07 Thread anil kumar
Dear vivek, can u send sample sheet Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may n

$$Excel-Macros$$ VLOOKUP FROM A RANGE OF SHEETS

2012-06-07 Thread vivek
I have created a file index , with separate sheets alphabetically. Now I want to use the vlookup function in a new file, wherein I would type the clients name , and it should lookup the file number from the index file. Is it possible? Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI)