VLOOKUP WITH MACRO

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup result in a message box 10
What is the VBA equivalent of the excel function VLOOKUP 4
macro 4
Runtime error 1004 when trying to insert formula in cells 11
EXCEL - IF(IFERROR(VLOOKUP question 0
vlookup 2
VLOOKUP 2
VBA userform Vlookup Excel 1

Back
Top