You are missing a double quote before D5 and a right paren.

I think it should be
(LEFT(range("D5"),3),range("HTC!A2:A200"),range("H TC!b2:B200"))

hth,

Doug

"Dthmtlgod" wrote in message
...
I was given this piece of code by an MVP, and I think I am missing a
reference.

dim res as variant
res =

application.lookup(LEFT(range(D5"),3,range("HTC!A2 :A200"),range("HTC!b2:B200
"))

I don't get the lookup option after typing in application.

Please advise.