worksheetfunction.vlookup not working as expected.

[dmcgov]

so i have the following code:

Please Login or Register  to view this content.

when i run it, i get a runtime error 1004 - Unable to get the vlookup property of the worksheetfuncion class on this line:

Please Login or Register  to view this content.

it correctly prints the range address in the immediate window

what am i doing wrong?

[TMS]

Please heed the yellow banner at the top of the page.

[dmcgov]

tms, not sure if i can upload the addin as it is very big. and the workbook with the code in it contains confidential information. what can i do in a case like mine where uploading is not suggested?

[Fluff13]

Chances are it can't find the the value of "i" in the lookup table.

[MrShorty]

With an exact match lookup like this, that error usually means that the lookup value (i in this case) does not exactly match any entry in the leftmost column of the lookup range (The "vendnamnum" named range). I would be looking at what is in i, and what is in the leftmost column of vendnamnum and try to see why i is not being found.