What formula can be used to share data in 2 sheets
Closed
NKERAGUTABARA
-
10 Oct 2017 à 06:04
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Oct 2017 à 11:15
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Oct 2017 à 11:15
Related:
- What formula can be used to share data in 2 sheets
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- How to copy data from one excel sheet to another - Guide
- Google sheets download - Download - Spreadsheets
- Five nights in anime 2 - Download - Adult games
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Oct 2017 à 11:15
10 Oct 2017 à 11:15
Hi NKERAGUTABARA,
On sheet A use:
=IF(ISERROR(VLOOKUP(A2,B!$A$2:$A$5,1,0)),"Not found","Found")
On sheet B use:
=IF(ISERROR(VLOOKUP(A2,A!$A$2:$A$5,1,0)),"Not found","Found")
Adjust the bold parts to match the number of rows used.
You can then apply a auto filter to group the results together.
Best regards,
Trowa
On sheet A use:
=IF(ISERROR(VLOOKUP(A2,B!$A$2:$A$5,1,0)),"Not found","Found")
On sheet B use:
=IF(ISERROR(VLOOKUP(A2,A!$A$2:$A$5,1,0)),"Not found","Found")
Adjust the bold parts to match the number of rows used.
You can then apply a auto filter to group the results together.
Best regards,
Trowa
