Hey I am looking for ideas on how I can compare a column of names with userid's. In column "A" I have 30 + Last names. In column "F" I have 20+ names. There are not always matches for both. Some names missing, some Id's missing. also some last names are the same and are long enough that the userid just includes last name letters. 'Hatcher' for a name may equal 'Hatche' for an userid. If you have two 'Hatcher's' then I would like to change the color to yellow for the last name column just for those that have the same last name and not move or copy them. For those that are missing a last name or ID I will have to work out external to excel, they can be left alone. For those last names that match the first few letters of the Userid, I would like them to copy from column "A" into column "E" -right beside the Userid in 'F'. The last name and and Userid are hardly ever in the same row. Also the userid format varies but always includes 3+ letters of the last name in the beginning. I do relize that only matching 30+ names isnt much, but I have this to do on 24 excel sheets every month and would just like to automate the process as much as possible. Please suggest ideas if you can. For all of it or only part that you may know.