Related:
- Compare columns in two sheets and copy info across
- Excel - Comparing columns from different sheets - How-To - Excel
- Comparing columns in two different excel sheets and if they match copying third column ✓ - Forum - Excel
- Macro to compare two columns in different sheets in excel ✓ - Forum - Excel
- Compare values in two columns and return the value from third ✓ - Forum - Excel
- How to compare two columns in excel sheet - How-To - Excel
1 reply
Mazzaropi
- Posts
- 1852
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- November 7, 2020
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
Subscribe To Our Newsletter!
