Frequently we get a requirement to compare two lists i.e.Determine weather a value in one column exist in second column or not and viceversa.
Excel provides a very useful function, LOOKUP and VLOOKUP, for this.
Here is complete detail article about this functions with example and pictorial view of it.
http://www.techonthenet.com/excel/formulas/lookup.php
Hope you'll find it useful.
