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.