Compare two columns in excel

This Video shows how to compare two columns in excel using the VLOOKUP formula.By using this technique you can easily find the items in column A which are not present in Column B. Formula copy paste this in column C: IFISNAVLOOKUPA2 B2:B91FALSENOT FOUND FOUND Note: if you have 100 rows of data just change B2:B9 to B2:B100 meaning data starts at row 2 and ends at row 100 Click here for new video ,

#