compare data in 2 worksheets

J

Josh

I have two separate worksheets with similar data, Worksheet1 and Worksheet2.
Columns A - F in each worksheet contain data. Column A in Worksheet1 and
Column A in Worksheet2 contain an account number. How can I compare the
account numbers in the two worksheets so that if the account number is in
Worksheet1 but not Worksheet2 it will produce the word "no" in Column G in
Worksheet1?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top