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.


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




"Milind" wrote in message
...
In my sheet, two columns Accounts & Descriptions exist. The
entries would be
unique, that is for a particular Account only one type of
description (e.g.
Pills) be there.

Now, I want is that
If accnt = 2345 AND descp = "pills" Then
do something
endif

Excel does not allow me do that. Can anyone help?

Milind


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003