how to transfer data to another sheet

[Libreaccount]

If you look in the attachment I have two columns of data in two sheets. Both sheets labelled “Items” and “Market items” within each sheet have TYPEID and TYPENAME. I would like to move volume over to Market items.

The first sheet holds all the items in existence in this on line game (eve-online) whilst the second sheet holds only the data that can be sold in market. I can’t just cut and paste volume over.

Any help would be great.help.ods

[mariosv]

If there are not duplicates in Items sheet the you can use a function like

=VLOOKUP(A2;$Items.A:C;3;0)

If there are several with the same TYPEID then a function like

   =SUMIFS($Items.C:C;$Items.A:A;A2)

[Libreaccount]

Superstar. Thanks a lot.

[mariosv]

Please use comment, this in not an answer.
.
if the answer solves the question click .

[Libreaccount]

i can’t find the tick. But it is resolved

[mariosv]

< 0 > .