If word =A, enter word B!

[Casi12]

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?!

 

[Gary''s Student]

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.

 

[JE McGimpsey]

One way:

Put the list in, say, another sheet ('Sheet2'):

A B
1 horses alert
2 cows lethargic
etc.

Then use

B2: =VLOOKUP(A1,Sheet2!A:B,2,FALSE)

 

[Gord Dibben]

You can use a VLOOKUP formula.

You need a two column table with list of originating words and instruction words
and an input cell.

=VLOOKUP(A1,$AA$1:$AB$100,2,FALSE) entered in B1

Type "horses" in A1 and B1 will return corresponding text from AB1


Gord Dibben MS Excel MVP

 

[Casi12]

Thank you so much for your help! This is such a great forum!
Casi

 

[Casi12]

Thank you so much for your help! Works perfectly! I love this forum. It's so
incredibly helpful!
Casi

 

[Casi12]

Thank you so much for your help! Works perfectly!
Casi