Identify value 1 in a wbook and copy values in the same row as value 1 in another wbook

[ripis]

Hi,

I have some simple VBA skills. However, this time I am somewhat "over my head". This is what I'm trying to do:

I have to different workbooks, book1 and book2, (as shown attached).

From book1 I want data from columns as Tag, Type etc. placed in the right columns in book2.
From book2 the only info I have is the SFI_ITEMNR. (the Handle and Blockname are random), so I somehow need to use these values and identify the corresponding SFI values in book1. The VBA code then have to copy the needed values (like Tag, Type etc.) from book1 to the right rows and columns in book2.

So, if anyone have any ideas please let me know. All help is much appreciated.

Thank you!