Hello All,

I have an excel spreadsheet that I need to search a keyword in column E and when it finds the particular word it needs to assign it a number in column U which is blank. Example: All rows containing the word “hat” in column E will need to be assigned the number 557 in column U. I know I can sort & filter but I will need to do this weekly from excel files sent to us. Can this be done using formula?

Thanks for all the help.

gsmonk