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

Similar Threads

I need a cell to be blank. 4
linking cells when embedding into Word documents 0
DBSUM function but with function as criterion, not a range 3
Need help with this formula 1
Sort one coloumn according to another coloumn on another worksheet 0
How to compare a row data from one worksheet to another worksheet 5
Sort a coloum on one worksheet according to another coloumn on ano 0
Formula questions 3

Top