$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Ayushj
Dear Members, Can anyone assist Suresh on his query ? Thank you. On Jul 16, 12:57 pm, suresh k brave.sur...@gmail.com wrote: Hi I have one query. I have data in two different sheets. Below are example for you. *Data in sheet 1:* Name       Data          Date          No. Su          

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Dilip Pandey
Hi Suresh (Brave man) Solution is attached. Enjoy..!! This is slightly delayed as I was occupied with some other urgent project meetings. Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Dilip Pandey
Hi Ayush, Query raised by Suresh has been answered. Thanks. Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:29 PM, Ayushj

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Atul Kesaria
Hello Suresh, Please find the attached sheet, hope this is what you are looking for. Thanks and Regards Atul Kesaria On Thu, Jul 16, 2009 at 1:29 PM, Ayushj jainayus...@gmail.com wrote: Dear Members, Can anyone assist Suresh on his query ? Thank you. On Jul 16, 12:57 pm, suresh k

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Mahesh R
Concatenate the two fields(Name Data) in both sheets and then put Vlookup.. On Thu, Jul 16, 2009 at 1:29 PM, Ayushj jainayus...@gmail.com wrote: Dear Members, Can anyone assist Suresh on his query ? Thank you. On Jul 16, 12:57 pm, suresh k brave.sur...@gmail.com wrote: Hi I

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Atul Kesaria
Sorry, Please find the revised file On Thu, Jul 16, 2009 at 2:27 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hello Suresh, Please find the attached sheet, hope this is what you are looking for. Thanks and Regards Atul Kesaria On Thu, Jul 16, 2009 at 1:29 PM, Ayushj

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread mohsin pokar
Suresh Key in this formula, this will serve. Unable to upload xls from my end. Please read alphabets as columns. *Sheet 1* ** ** *C* *D* *E* *F* Name Data Date No. Su 12 01/01/1999 123 gu 22 02/02/1999 124 gg 33 03/03/2000 125 *Sheet 2* ** ** ** ** *C* *D* *E* *F* *G* *H* Name Data Date

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread vikas gupta
HI EVERYBODY I CANT UNDERSTAND THE STEPS OF VLOOKUP FORMULA PLEASE SOLVE IN ATTACHED FILE VIKAS On Thu, Jul 16, 2009 at 5:03 PM, Dilip Pandey dilipan...@gmail.com wrote: Hey Ashish... Thanks a TON...!!! Remeber.. Everyone is learning here.. including me as well..!! Best Regards,

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread suresh k
Hi All, This formula is working fine, But when i apply this formula to a very large data. It is not showing accurately. And this formula tells that it will look into only a particular cell. But i need some formula where it should search for all cells in a particular column. On Thu, Jul 16, 2009

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Ayushj
Thanks Dilip and everyone for solving the issue. Appreciate all your knowledge !!! On Jul 16, 2:29 pm, Dilip Pandey dilipan...@gmail.com wrote: Hi Ayush, Query raised by Suresh has been answered. Thanks. Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY