How I can use the VLOOKUP function with Excel macro.
thanks

Hello yusuf
You may use eiher:
Evaluate("=VLOOKUP(C3,A1:B5,2,FALSE)")
or
Application.WorksheetFunction.VLookup(Range("C3"), Range("A1:B5"), 2, False)

HTH
Cordially
Pascal


"yusuf" a écrit dans le message de news:
...
How I can use the VLOOKUP function with Excel macro.
thanks

Hi Papou
Thank you for helping me, I try to run the following macro but still give me
error please if you can help me in this matter.

Sub Test()
B2 = Application.WorksheetFunction.VLookup(Range("A:A") ,
Range("[bank_database.xls]Sheet1!$A:$B"), 2, False)
End Sub

thanks you
"papou" wrote:

Hello yusuf
You may use eiher:
Evaluate("=VLOOKUP(C3,A1:B5,2,FALSE)")
or
Application.WorksheetFunction.VLookup(Range("C3"), Range("A1:B5"), 2, False)

HTH
Cordially
Pascal


"yusuf" a écrit dans le message de news:
...
How I can use the VLOOKUP function with Excel macro.
thanks