vlookup code

avvamma

New Member
Hi,

I have an requirement to apply vlookup on two different workbook.
I have to compare one column from one workbook to another workbook if its matching then i need to write 2 more columns in 1st workbook.

can anyone help me to write small piece of code for this?

Thanks
 

sivagelli

Well-Known Member
Here is the vlookup example you can use in one of the workbooks and refer to the other workbook. Here i am referring cells A5 to B70 in Sheet1 of Dept.xlsx workbook from other workbook-

"=vlookup(A1,'C:\Department\[Dept.xlsx]Sheet1'!$A$5:$B$70,1,FALSE)"
 
Top