Hi,

I have this in my spreadsheet excel 2003

worksheet 1 worksheet 2 worksheet 3

column A column A column B

Civil Isometrics Turbines
Mechanical Vendors Electrical
Electrical Scope Waste Managemet
Instrument Electrical QMS
.......ans so on

I want to find the word "Electrical" from my 3worksheets and the results
will appear next to the cell of worksheet 1 column A which is column B and C,
like this

w o r k s h e e t 1
column A column B column C

Civil
Mechanical
Electrical Electrical Electrical
Instrument

how would write my formula?

thanks for any help, I appreciate