Search and Replace

[Rebecca]

Greetings. Is this possible in Excel 2007 (beta)? I have four columns: A,
B, C, and D (which is blank). If the word in a particular row in A is "hat,"
the word in the same row in B is "bug," and the word in the same row in C is
"flower," I want to place the word "tree" in the same row in blank column in
D. I want this to happen to all the rows with this particular combition
(hat, bug, and flower). Of course, I will go through the spreadsheet row by
row to fill in all the words. This is a translation exercise, with A (the
Hebrew word), B (the parsing), and C (the dictionary form of the word in A)
words in one langauge (Hebrew), and D will be the translation of the words
(in English). I hope this will not involve complicated programing or macro
building, because I am a new user. If this is possible, and if so could you
please explain to me how to do this, and in simple English, step-by-step?
Thanks.

 

[Rebecca]

Oh, and to reply to my own post, if you think it strange to be doing
something this in Excel, there is a reason I'm using it instead of, say,
Access or the like. I realize Excel is mostly used for calculating and the
like, but after each word is translated into English, there will be some
calculations done here and there.

 

[Peo Sjoblom]

In D2 (or whatever row your data starts) put

=IF(AND(A2="hat",B2="bug",C2="flower"),"tree","")


copy down, if you want some more flexibility you can use

=IF(AND(A2=$F$1,B2=$G$1,C2=$H$1),"tree","")

where you would put the 3 words in F1, G1 and H1 respectively

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey