Vlookup Error - unable to get the vlookup property of the worksheetfunction class

Hi All,

I am trying to create a vlookup with the code below but I get the error '- unable to get the vlookup property of the worksheetfunction class'. I think the issue is the array i have declared but I am not sure. Any help is greatly appreciated.

Please Login or Register  to view this content.

Kind regards,

James Elwell

That error probably means that the lookup value wasn't found. Try

Please Login or Register  to view this content.

It worked thanks so much!!

You're welcome & thanks for the feedback