Search and Replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top