Comparing columns on two different spreadsheets
Closed
willerdt
Mazzaropi
- Posts
- 1
- Registration date
- Monday August 1, 2016
- Status
- Member
- Last seen
- August 1, 2016
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Comparing columns on two different spreadsheets
- Comparing 2 columns from 2 different spreadsheets ✓ - Forum - Excel
- Excel - Compare column A & B give results in column C - How-To - Excel
- Comparing columns and returning value ✓ - Forum - Excel
- Compare columns and create list of duplicates ✓ - Forum - Excel
- Comparing columns in Excel 2010 ✓ - Forum - Excel
1 reply
Mazzaropi
Aug 1, 2016 at 01:50 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Aug 1, 2016 at 01:50 PM
willerdt, Good afternoon.
You can use a VLOOKUP Function or a combination of INDEX + MATCH Functions.
It depends on the layout of your files.
As you did not mentioned how is your layout, we can not helps you conclusively at this moment.
If you want, save your file at a free site, www.speedyshare.com, and put a link to download here.
It's easier for us to help you.
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You can use a VLOOKUP Function or a combination of INDEX + MATCH Functions.
It depends on the layout of your files.
As you did not mentioned how is your layout, we can not helps you conclusively at this moment.
If you want, save your file at a free site, www.speedyshare.com, and put a link to download here.
It's easier for us to help you.
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
