If word =A, enter word B!
 

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

If word =A, enter word B!
 

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

If word =A, enter word B!
 

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)




In article ,
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?!

If word =A, enter word B!
 

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

On Tue, 24 Jun 2008 06:56:00 -0700, 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?!

If word =A, enter word B!
 

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

"Gary''s Student" wrote:

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

If word =A, enter word B!
 

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


"Gord Dibben" wrote:

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

On Tue, 24 Jun 2008 06:56:00 -0700, 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?!

If word =A, enter word B!
 

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

"JE McGimpsey" wrote:

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)




In article ,
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?!

If word =A, enter word B!
 

"Casi12" wrote in message
...
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?!

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

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