First time poster here...I need help moving matching information from one worksheet to another. I have a worksheet with a list of zip codes in column A. The corresponding county for that zip code is in column B-(we'll call this sheet 1). The other is a customer list with complete address that include a zip code, but not the county (we'll call this sheet2). I need to have the zip from list 2 match to the zip on list 1 and drop the corresponding county name into the cells. In the end I need to have a customer list that includes the county. In the past I have sorted by city and then copied the county into the cells. I have several thousand records, and the copy paste option gets to be a little too much. I am sure there is a simple fix, but for the life of me I can't get it straight.