If two cells don't equal each other, notify; if they do equal each other, do a "sum"

Giganews Newsgroups
Subject: If two cells don't equal each other, notify; if they do equal each other, do a "sum"
Posted by:  rbrown9…@gmail.com
Date: Tue, 3 Mar 2009

I'm building a quoting tool for my sales organization and I want to
make sure I'm using the most recent pricelist.  My operations group
sends out a spreadsheet with the most recent pricing that I save to a
specific location.  Then I have a worksheet in my quoter workbook that
syncs with what operations sends when I do a "refresh all".  There is
a unique identifier in the pricelist that identifies it as the most
recent version.  What I want to do is compare the identifier in the
worksheet called "Database" against the identifier in the pricelist
and if they're not the same, say "NOMATCH" and if they are the same,
go ahead and sum the contents of some cells.  Here's what I have
written, but it's not doing anything except returning "NOMATCH".  What
have I done wrong?

=IF(ISERROR(MATCH(+Database!G7,'C:\saved location\[pricelist.xls]
pricelist'!$G$1,0)),"NOMATCH",(SUM(I19:I20)))

Replies