Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

What formula can be used to share data in 2 sheets [Closed]

Report
-
Posts
2718
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 15, 2021
 -
Hello,

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.

kind regards

1 reply

Answer 1 / 1
Posts
2718
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 15, 2021
 459
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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!