What formula can be used to share data in 2 sheets
Closed
NKERAGUTABARA
-
Updated on Oct 11, 2017 at 09:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 10, 2017 at 11:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 10, 2017 at 11:15 AM
Related:
- What formula can be used to share data in 2 sheets
- Tentacle locker 2 - Download - Adult games
- Five nights in anime 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Share internet from pc to iphone - Guide
- Euro truck simulator 2 download free full version pc - Download - Simulation
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 10, 2017 at 11:15 AM
Oct 10, 2017 at 11:15 AM
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
