Vlookup from another sheet in vba

[G2K]

Hi all,

I am trying to insert values into an adjacent cell based upon lookup
values entered using VBA(referecing another workbook- sheet2), i have used other functions in my sheet and it's working like a charm but i am not able to get the vlookup function running till now.

what i actullay want here is -

Range("Y2").Resize(.Range("B65536").End(xlUp).Row - 1, 1).Formula =

Vlookup(Y2,WB name -Master! sheetnumber(2)!range(Y:Z),2,0)

Any Idea ??

 

[andylawson5]

I think you need single quotes around the sheet name and you dont need the range. What if you try this:

= "=VLOOKUP(Y2,'WB name -Master! sheetnumber(2)'!Y:Z,2,FALSE)"