compare data in 2 worksheets

G

Guest

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

Similar Threads

I need a cell to be blank. 4
DBSUM function but with function as criterion, not a range 3
Comparing columns from 2 different worksheets. 1
Need help with this formula 1
Formula questions 3
sorting through unknown source data as it is entered 1
Data consolidation from Multiple Sheets 1
How to compare a row data from one worksheet to another worksheet 5

Top