VBA Macro code - import data from another workbook (VLOOKUP)

Hello,

I am still new to vba, and i need your help.

Can you please help me with a macro VBA code (in file A) for importing data from another workbook (file B).

The original formula that I have at this moment is:

Formula:

Please Login or Register  to view this content.

.
.
.

Formula:

Please Login or Register  to view this content.

- import items from different columns.

Both file are saved in the same folder, and open.

I have now found the following code...it works for column B (In file A) ... but how to do it for the other columns?

Please Login or Register  to view this content.

The original files, on which I want to use this vba code has more than 10 000 rows. As attachment only some samples.

Thank you in advance for your help.

Madi1004

It is probably not super-fast code, but it sees it cam be working one.
So I am not suggesting a new one but just improving the existing one.
The equivalent to thitd argument in VLOOKUP is here

Please Login or Register  to view this content.

This offset 3 (columns) means the same as 4th column in your first formula.
So you can ammend your Findingname function to be more universal one by adding a second argument

Please Login or Register  to view this content.

and call it several times:

Please Login or Register  to view this content.

or another way:

Please Login or Register  to view this content.

Thank you for your help.

You are right, this code is very slow. Do you have one that is faster?

I am a beginner in VBA.
Using the above code i get an error in the line

Please Login or Register  to view this content.

Can you please help me!

Thank you

If you are using this version of FindingName function:

Please Login or Register  to view this content.

you cannot use

Please Login or Register  to view this content.

to call it. You have to use 2 arguments - sname and kolumn to be returned number.

Hello,

Thanks once again for your help. The import of data is functioning, but some prices are wrong (please see attachment - last column cells marked with red). The source workbook(file B) is in the first post.

Do you have a solution for this?

Thank you,
madi1004