VLOOKUP form a workbook to another one

[ABaggins]

Hello
I have this problem. I am trying to make several files that grab information from another workbook with loads of rows with lots of data. So I'm trying to use the vlookup function to grab that information when it is required. I am not really good at this and all I know I've learned it myself so sorry if there are many many mistakes. Here is what I've written

Please Login or Register  to view this content.

Thank you for all of your help!

[ABaggins]

The problem is in the WorksheetFunction.VLookup part. I get a mistake saying that it is the mistake 1004 and that Vlookup cannot be obtained from worksheetfunction

[FDibbins]

why do you need to do this through a macro? would a simple vlookup() formula not do what you need?

[ABaggins]

Thank you!
Well, in that part it could be changed just as you say, but I was trying to make that part work because I was using the same function afterwards, searching different lines of every category,but now since you are saying it can be changed I think that it could be replaced by just copy-pasting the information like this

Please Login or Register  to view this content.

I'll try to do that properly then!