What formula can be used to share data in 2 sheets
NKERAGUTABARA -
Oct 10, 2017 at 06:04 AM - Latest reply: TrowaD2369
Posts Sunday September 12, 2010Registration dateModeratorStatus
June 21, 2018
Last seen
- Oct 10, 2017 at 11:15 AM
I have two excel sheets A and B having the same columns. there names, dates, figures. not necessarily having the same number of rows, having same names in some cases, in other cases not same names.
i would like to have a formula to compare B to A to track which names in B appear in A and which names in A not appearing in B.
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.
