Use =VLOOKUP()
Say in A1 thru B10 we have:

horses alert
dog bark
cat meew
frog croak
bee buzz
lion roar
goat baaa
cow moo
pig oink

and if D9 contains horses then:

=VLOOKUP(D9,A1:B10,2,FALSE) will retrun alert.
--
Gary''s Student - gsnu200793


"Casi12" wrote:

Hi there

I have a list of words. I need a cell that will look up that word and return
another word. For example. If A1=horses, B2=alert. I have a number of
originating words and a number of instructions that need to be displayed
depending on that originating word. Can anyone help?!