This is what I answered when you posted a similar question in new users
albeit with different words and A, B and C

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


"Rebecca" wrote in message
...
Greetings, again. I think I asked for help in the wrong place, so please
forgive me for posting this again (though I am a new user, indeed). By
the
way, this is not a homework assignment, so feel free to give some advice
(in
step-by-step easy English, please).

I am using MS Excel 2007 (beta). I have four columns: A, B, C, and D (D
is
blank). If the Hebrew word in a particular row in Col. A is, say, "gggg,"
the parsing (grammar) in the same row in Col. B for that word is "nbcpd,"
and
the Hebrew word in the same row in Col. C is "gggdd" (the dictionary form
for
gggg in Col. A), I want to place the word "tree" in the same row in blank
column in Col. D (the English translation of the word in Col. A, with the
information in Cols. B and C taken into consideration -- tense, number,
gender, etc.).

I want to go down the spreadsheet one row / word at a time (each row is
one
Hebrew word) and fill in every blank in Col D., but I want to remain in
the
same row (or maybe come back to it, however this could be done) and
translate
all the other rows with the same A, B, and C combinations.

I hope I haven't been too clumsy in explaining what I am trying to do. I
don't want to use Access for a reason I won't go into here (there are
certain
calculations that I would like to do later in Excel). Could someone please
help me with this problem? Thank you.