If word =A, enter word B!

C

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

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.
 
J

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)
 
G

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
 
C

Casi12

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

Vass

Casi12 said:
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?!
Click to expand...

in B1 type =if(a1="word","answer","")

this will only look for the occurrence of "word" not a combination of
different queries and answers.
 
Top