$$Excel-Macros$$ Re: Doubt on using vlookup function from another sheet

2009-06-11 Thread Dilip Pandey
*Hi Ramesh,* Solved workbook is attached with this email. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jun 11, 2009 at 5:19 PM, Ramesh Katta wrote: > Hi Dear members, > > I have a doubt on

$$Excel-Macros$$ Re: Doubt on using vlookup function from another sheet

2009-06-11 Thread Ramesh Katta
Hi Amithab, Thank you very much. Regards Ramesh On Thu, Jun 11, 2009 at 7:09 AM, Amitabh Bose wrote: > > Hi Ramesh, > > Please find the file attached with the vlookup formula. > > The basic formula is: > =VLOOKUP($A3,Sheet1!$B$4:$F$18,4,0) > > The ISNA formula is to replace any blank cells whic

$$Excel-Macros$$ Re: Doubt on using vlookup function from another sheet

2009-06-11 Thread Amitabh Bose
Hi Ramesh, Please find the file attached with the vlookup formula. The basic formula is: =VLOOKUP($A3,Sheet1!$B$4:$F$18,4,0) The ISNA formula is to replace any blank cells which come up with NA# with 'blank' cells. Hope this helps. Regards, Amitabh > Date: Thu, 1