I have a workbook with two sheets, I'm trying to figure out how to make it take use the value from each cell in column E of sheet 2 and search all of column A in sheet one, then if a matching value is found run a different function... I've tried a number of methods I have found and something goes really wrong every time I try and make them work.... Any suggestions?