Vlookup

[sur]

Hello

i have a excel file named "A" in a folder and other excel file for mapping

i need to do vlookup in coloumn E for coloum B looking in to mapping table

of sheet1 column a and B

=vlookup(B1,mapping table,2,0)

the daily data will be increasing in workbook A

 

[Smitty]

Welcome to the Board!

So what's the question?

 

[sur]

Hello

i have a excel file named "Sur" in a folder and other excel file for Table

i have done a vloop in the in sur with using the table file i need to do it with vba code please help me. i data in the sur file will be increasing daily

Please find the attached excel files names Sur and Table in the below link

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20>https://skydrive.live.com/?cid=f87dac06ca84de0d&sc=documents&id=F87DAC06CA84DE0D%21102#!/?cid=f87dac06ca84de0d&sc=documents&uc=1&id=F87DAC06CA84DE0D%21102</TD></TR></TBODY></TABLE>