Comparing Spreadsheets
Closed
melbaboone
Posts
1
Registration date
Thursday October 8, 2015
Status
Member
Last seen
October 8, 2015
-
Oct 8, 2015 at 03:38 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 05:14 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2015 at 05:14 PM
Related:
- Comparing Spreadsheets
- What is a function in relation to data processing using spreadsheets - Guide
- How to compare two excel spreadsheets - Guide
- You are updating a master spreadsheet for the sales team and want it to automatically update the data in another spreadsheet. so you don't have to manually update two spreadsheets, how would you do this? ✓ - Excel Forum
- Comparing two excel files - Programming Forum
- Comparing two excel worksheets ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 8, 2015 at 05:14 PM
Oct 8, 2015 at 05:14 PM
melbaboone, Good evening.
There are a lot of ways to do this.
My suggestion:
Suppose:
Sheet1
A1:A500 - Names
Sheet2
C1:C1000 - Names
Try to use:
Sheet1
B1 -->
=IF(ISERROR(MATCH(A1;Plan2!C1:C1000,0)),"NOT FOUND","----OK----")
Sheet2
D1 -->
=IF(ISERROR(MATCH(C1;Plan1!A1:A500,0)),"NOT FOUND","----OK----")
Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
There are a lot of ways to do this.
My suggestion:
Suppose:
Sheet1
A1:A500 - Names
Sheet2
C1:C1000 - Names
Try to use:
Sheet1
B1 -->
=IF(ISERROR(MATCH(A1;Plan2!C1:C1000,0)),"NOT FOUND","----OK----")
Sheet2
D1 -->
=IF(ISERROR(MATCH(C1;Plan1!A1:A500,0)),"NOT FOUND","----OK----")
Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
