Compare columns in two sheets and copy info across
[Closed]
Report
pashnak
-
Mazzaropi
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
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
- Compare values in two columns and return the value from third ✓ - Forum - Excel
- Excel - Compare column A & B give results in column C - How-To - Excel
- Copy same column from multiple sheets - How-To - Excel
1 reply
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
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
