Compare columns in two sheets and copy info across
Closed
pashnak
-
Feb 22, 2017 at 09:39 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 22, 2017 at 10:57 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 22, 2017 at 10:57 AM
Related:
- Comparing columns in two different excel sheets and if they match copying third column
- Display two columns in data validation list but return only one - Guide
- Mark sheet in excel - Guide
- Number to words in excel - Guide
- How to open excel sheet in notepad++ - Guide
- If two cells match return value from third excel ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
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