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