Searching for text and adding a number value?

**gsmonk** · 11-24-2007, 06:45 PM

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

**davesexcel** · 11-25-2007, 12:41 AM

Originally Posted by gsmonk

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

I supposed a lookup, formula would work
http://www.contextures.com/VLookupSample.zip
check out the report card worksheet the data is from the grades worksheet

http://www.contextures.com/xlFunctions02.html