Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Callum Smith   on Sep 02 In MS Office Category.

compare data in two sheets


  
Question Answered By: Amelia Schmidt   on Sep 02

I would identify the matches on the sheet by using MATCH.

Put a formula in sheet1  cell B1 like =MATCH(A1,Sheet2!$A$1:$A$7,0) you will
get the row number of the corresponding value (or #N/A if there is no match).
You can then use the row number in the macro.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on compare data in two sheets Or get search suggestion and latest updates.


Tagged: