Formula for yes or no for certain words.

[hotrod]

I have a 2010 excel spreadsheet. Column B is where I want the value to be yes or no when I type in a certain word in column A.
EG
Column A has – investigate, research, formula, test, results etc
Column B – I want the formula to recognise the words in column A to put in a yes or no against a the word.
investigate=yes, research=yes, formula=no, test=yes, result=no

Thanks in advance.

 

[BiocideJ]

Like this?

Excel 2007
	A	B	C	D	E	F	G
1	Word	Yes/No					Yes Words
2	investigate	Yes					investigate
3	research	Yes					research
4	formula	No					test
5	test	Yes
6	result	No
Taxes2010

Cell Formulas
Range	Formula
B2	=IF(ISERROR(VLOOKUP(A2,$G$2:$G$1000,1,FALSE)),"No","Yes")
B3	=IF(ISERROR(VLOOKUP(A3,$G$2:$G$1000,1,FALSE)),"No","Yes")
B4	=IF(ISERROR(VLOOKUP(A4,$G$2:$G$1000,1,FALSE)),"No","Yes")
B5	=IF(ISERROR(VLOOKUP(A5,$G$2:$G$1000,1,FALSE)),"No","Yes")
B6	=IF(ISERROR(VLOOKUP(A6,$G$2:$G$1000,1,FALSE)),"No","Yes")

 

[c_m_s_jr]

Another way:

=LOOKUP(A1,{"Formula","Investigate","Research","Results","Test"},{"yes","yes","no","yes","no"})

 

[hotrod]

c_m_s_jr - works perfectly. Thanks heaps

BiocideJ - your formula did not work. When there is no text entered into column a, column b has no.