Hi,

Your information is a little sparse, but
Sub Macro1()
'Run from Book1, cell A10, looking up value in Book1 cell E10
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[4],[Book2]Sheet1! _
R1C5:R1C6,2,FALSE)"
End Sub

Maybe this will help?
David
"Yossy" wrote:

Please I need help in vlook up using macro. I have multiple sheets in a Wk
book and would like to lookup E5 from data range in another workbook and
return column 2 data.

I want the result to be displayed in A10 across multiple sheets based on
their corresponding E5 cell lookup value.

Wk Book 1
Sheet 1 Cell E5
J45Offe_1

Sheet 2 Cell E5
Pl09Kiy_6

Wkbook 2
Cell A1 J45Offe_1 CEll B1 JungleBoy
Cell A2 Pl09Kiy_6 Cell B2 HuntingWizz

Final Output
For Sheet 1
Cell A10 = JungleBoy

For Sheet 2
Cell A10 = HuntingWizz