Compare columns in two sheets and copy info across
Closed
pashnak
-
Feb 22, 2017 at 09:39 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Feb 22, 2017 at 10:57 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Feb 22, 2017 at 10:57 AM
Related:
- Comparing columns in two different excel sheets and if they match copying third column
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Excel intersection of two columns - Excel Forum
- Excel match two columns and output third ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- Auto serial number in excel based on another column ✓ - Excel Forum
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Feb 22, 2017 at 10:57 AM
Feb 22, 2017 at 10:57 AM
Steve, Good afternoon.
Suppose this scenario:
Sheet1
A1:A10 --> PO number
B1:B10 --> Value
C1:C10 --> Supplier Name --> FORMULA
Sheet2
A1:A20 --> PO number
B1:B20 --> Supplier Name
Try to use:
Sheet1
C1 --> =VLOOKUP(A1, Sheet2!$A$1:$B$20, 2, FALSE)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose this scenario:
Sheet1
A1:A10 --> PO number
B1:B10 --> Value
C1:C10 --> Supplier Name --> FORMULA
Sheet2
A1:A20 --> PO number
B1:B20 --> Supplier Name
Try to use:
Sheet1
C1 --> =VLOOKUP(A1, Sheet2!$A$1:$B$20, 2, FALSE)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão