Copy linked fields in excel spreadsheets

[Closed]
Report
Posts
1
Registration date
Thursday October 11, 2012
Status
Member
Last seen
October 11, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have two excel spreadsheets, that have invoice number as a common field. In sheet A, the the invoice number might repeat in 5-10 rows, once per product line. in sheet B, the invoice number is displayed only once, with shipping method. I need to link the two sheets, and copy the shipping method from the second sheet in a new column. Each line in sheet A has to have the shipping method from Sheet B

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use vlookup