Hi
try:
Range("b50").Value = WorksheetFunction.VLookup(range("a50"),
range("c39:d40"), 2, 0)

--
Regards
Frank Kabel
Frankfurt, Germany

"teresa" schrieb im Newsbeitrag
...
Hi All,
I'm trying the code below for a Vlookup and get
"Application-defined or Object-defined error",
I'd love to know why:

Sub fact()

Range("b50").Select
Range("b50").Value = WorksheetFunction.VLookup("a50", "c39:d40", 2,
[false])

End Sub