View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Casi12 Casi12 is offline
external usenet poster
 
Posts: 8
Default 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?!