Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

: $$Excel-Macros$$ Urgent help required for Vlookup macro code Hi Experts, I have data with Employee number,based on employee number i need to get the date of join.i have many file with DOJ. What is the VBA vlookup code for looking one file and if not find the DOJ filter blanks and asking next

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

Dear Nagendra, Please use it Sub USINGVLOOKUP() Dim X As Range Set X = Sheets(1).Range("$A$1:$D$9") Range("E15").Value =Application.Worksheetfunction.VLookup(Sheets(1).Range("B15").Value, X, 4, False) End Sub -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.bl

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

just share your data. Gawli Anil On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote: > Hi Experts, > > I have data with Employee number,based on employee number i need to > get the date of join.i have many file with DOJ. > > What is the VBA vlookup code for looking one file and if not find

$$Excel-Macros$$ Urgent help required for Vlookup macro code

Hi Experts, I have data with Employee number,based on employee number i need to get the date of join.i have many file with DOJ. What is the VBA vlookup code for looking one file and if not find the DOJ filter blanks and asking next file to lookup. Thanks in advance. -- Thanks&Regards Nagendra.