Vlookup application or object defined error... cannot figure out what's wrong

I have the following code:

Please Login or Register  to view this content.

The code for defining StepFour is fine, so there seems to be something wrong with my syntax. I've used the macro recorder to try to reproduce exactly what this is supposed to look like, and it looks exactly the same. I can't figure out why I'm getting an error.

The book I'm running this on (where column K is) is an .xls sheet, while the file I'm looking to is an .xlsx, but I've tried saving both as .xlsx or both as .xls and it doesn't make a difference.

Can anyone explain to me why I am getting this error: "Run-time error '1004': Application-defined or object-defined error."

I've also tried this as:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

As far as the code goes, what I have here column-wise is exactly what the recorder came up with. I'm looking from column K back to column A, (RC-10] to the workbook that I've named StepFour, on a sheet called Data, in columns 12-20.

I am so fed up with vlookup!

Try this:

Please Login or Register  to view this content.