Hi, Rebecca;
Here is another way. Select all the sheets. (Click first tab and shift+click
the last tab.) Assuming these words start on row 2, enter into E2 this
formula:
=IF(AND(B2="bword",D2="dword"),"eword","")
Replace:
bword with the word you are searching for in column B,
dword with the word you are searching for in column D,
eword with the word you want to place in column E.
Fill that formula down as far as necessary. (By grabbing the lower right
corner of the cell containing the formula, and dragging it down column E.)
Click any un-bolded tab to ungroup the sheets.
You're done.
Hope this helps.
Ian.

"Rebecca" wrote:

Hi. I am very new at using EXCEL 2003 and I was wondering if the program can
do the following: I want to search for a certain word in Column B and
another (usually different) word in Column D (both words are in the same
row), and replace a blank cell in Column E with a particular word (also in
the same row). And I would like to do this in all the sheets (that is, a
global search and replace). Could someone give me some advice as to how this
could be done? Please explain in easy English. Thanks.