Compare columns in two sheets and copy info across
Closed
pashnak
-
Feb 22, 2017 at 09:39 AM
Mazzaropi
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Compare columns in two sheets and copy info across
- VBA to compare column E from 2 sheets and copy entire row to sheet 3 ✓ - Forum - Excel
- Comparing columns in two different excel sheets and if they match copying third column ✓ - Forum - Excel
- Excel - Compare column A & B give results in column C - How-To - Excel
- Copy same column from multiple sheets - Guide
- Copy column from one sheet to another in excel using formula - Guide
1 reply
Mazzaropi
Feb 22, 2017 at 10:57 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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