Previous Topic Next Topic

Copy linked fields in excel spreadsheets

Closed
stogie Posts 1 Registration date Thursday October 11, 2012 Status Member Last seen October 11, 2012 - Oct 11, 2012 at 12:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2012 at 12:18 PM
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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 11, 2012 at 12:18 PM
you can use vlookup
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses