bonny, something like this, with list in column A put this in A1 and copy
down

=IF(A1="ford","yes","no")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"Bonny" wrote in message
...
Can anyone tell me what the formula is for returning a answer of yes or
no, i.e.
you have a list of cars and you want to mark all the ford cars with a yes
and all other cars as no.