$$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 wrote: > Hi Ayush, > > Query raised by Suresh has been answered. Thanks. > > Thanks & Best Regards, > DILipandey (Back from Holidays) > -- > DILIP KUMAR PANDEY >   MBA-HR,B COM(Ho

$$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 a

$$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 wrote: > Hey Ashish... > > Thanks a TON...!!! > > Remeber..>> "Everyone is learning here.. including me as well"..!! > > Best Regards, > DILipandey (Ba

$$Excel-Macros$$ Re: VLookup formula

2009-07-16 Thread Dilip Pandey
Hey Ashish... Thanks a TON...!!! Remeber..>> "Everyone is learning here.. including me as well"..!! 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,

$$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 Ashish Pradhan
Dilipji Even though the solution to this problem was not requested by me, I must tell you that just seeing the solutions you and a few others so regularly provide have helped me understand Excel a lot more. Thanks a lot for your contributions, Dilipji and many others who help us in understanding

$$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 wrote: > 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 wrote: > >> >> Dear Members, >

$$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 wrote: > > Dear Members, > > Can anyone assist Suresh on his query ? > > Thank you. > > On Jul 16, 12:57 pm, suresh k wrote: > > Hi > >

$$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 wrote: > > Dear Members, > > Can anyone assist Suresh on his query ? > > Thank you. > > On Jul 16, 12:57 pm, suresh k wrote: > > Hi > > > > I have one query. > > I have data

$$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 wrote:

$$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 New

$$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 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           12