IF function

[Texas10]

To be short and to the point, I've created a risk assessment for my company (rows are list of departments, columns are issues). The risks are labeled 1-5, 5 being the worst, and you can also insert T,P,or E. (T- training needed, P- Policy needed, E- Equipment required). I'm trying to search the risk assesment to for the letter T. When it is found I want excel to pull the department that needs training and drop in in the required traning tab. For example if T, then copy department name and place in table 2. I've tried =IF(SEARCH(cell#,cell#),Department name,""). It works as long as there is a T in the cell. If not, I get the wonderful #Value.

Any help would be greatly appreciated.

[Tony Valko]

Try something like this...

=IF(COUNT(SEARCH(cell#,cell#)),Department name,"")

[hemesh]

try this to hide errors
=if(iserr(IF(SEARCH(cell#,cell#),Department name,"")),"",IF(SEARCH(cell#,cell#),Department name,""))