If your question is in A1, answer is in B1, then this in C1

=IF(B1="pizza","Yes",IF(B1="bacon","No",""))

personally my fav is fish & chips

__________________
oldchippy
-------------


Click here >>> Top Excel links for beginners to Experts

Forum Rules >>>Please don't forget to read these