Transfer column values of one sheet to another linked to one row value

[Lisa93]

Hello,

I have three columns in one file that I would like to transfer into another file. The two files have one identical column and the data needs to be transferred into the right row of the information of that column.

excel transmission.jpg
/Edit: Group 3 = No Group

Would be nice, if someone could help me out!

Thank you

[José Augusto]

Try

In Sheet2!H2 and drag down and forward

Please Login or Register  to view this content.

Not tested

[Lisa93]

Thank you for your answer!

I get the right results for H2 and H3 (both 0), but than it shows #N/A for the rest.

[José Augusto]

Sorry,

Try again

Please Login or Register  to view this content.

[Lisa93]

Thank you very much!
I think you forgot a $ right before the B2? When I add the $, the autodrag to the right works fine.

[José Augusto]

You're welcome.