Thread: VLOOKUP as a vb code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default VLOOKUP as a vb code
Try this:

x = Application.WorksheetFunction.VLookup(Range("AZ4") , Sheet3.Range("A:B"),
2, 0)

Regards,
Per

"Tdp" skrev i meddelelsen
...
How do I change the following as a vb code???
=VLOOKUP(AZ4,Sheet3!A:B,2,0)
--
Tdp

Reply With QuoteReply With Quote