Comparing Spreadsheets
Closed
melbaboone
Posts
1
Registration date
Thursday 8 October 2015
Status
Member
Last seen
8 October 2015
-
8 Oct 2015 à 15:38
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Oct 2015 à 17:14
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Oct 2015 à 17:14
Related:
- Comparing Spreadsheets
- Google spreadsheets download - Download - Spreadsheets
- How to compare data in two excel spreadsheets - Guide
- Spreadsheets and formulas - Guide
- Comparing 2 worksheets in Excel - Excel Forum
- Comparing Column values with a constant - Programming Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
8 Oct 2015 à 17:14
8 Oct 2015 à 17:14
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
