Yep, that's what I meant.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Debra Dalgleish" wrote in message
...
I think Chip meant to write:

=IF(AND(A1=2345,B1="pills"),"Yes","No")

Chip Pearson wrote:
I'm not sure what your question is. Do you want a formula?

=IF(A1=2345,B1="pills"),"Yes","No")

Perhaps you could provide a few more details about what you
need.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html