Comparing columns on two different spreadsheets
Closed
willerdt
Posts
1
Registration date
Monday August 1, 2016
Status
Member
Last seen
August 1, 2016
-
Aug 1, 2016 at 01:24 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 1, 2016 at 01:50 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 1, 2016 at 01:50 PM
Related:
- Comparing columns on two different spreadsheets
- Display two columns in data validation list but return only one - Guide
- Compare excel spreadsheets - Guide
- Excel partial text match between two columns - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 1, 2016 at 01:50 PM
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
