Excel

How to Search for Values in a List Using Excel

It’s a common task for many analysts, and helpful for most people in general, so this post will outline how to search for values in a list using Excel. Let’s say you have a master list in column A. In this example, assume it is a list of current customers who have always paid their bills on time. Now your boss hands you another list, and it’s a list of customers who are late on their current bill. Perhaps they do not want to punish the customers who (to this point) have always paid on time, so it’s your job to find out which of the current ‘late’ customers have historically paid on time. This image below is a simplified version of what you may encounter, but the concept is the same.

Now it’s your job to find out if the late customers (Albert, Missy or Dick) have been good customers in the past. Read More…

 Scroll to top