Link two similar account lists

[tapperdan]

I have 2 similar customer lists with a unique account number for each customer in both lists. I would like to take list A and for each customer see if their account number is found in list B and if so place a "yes" next to their account number. I know I use an IF function but what is the logical test?

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-form...mer-lists.html