I've been using excel for 6 years and haven't come across this formula
question until now.

Ok, I have 2 worksheets, one being the pretty page that has the total
numbers for each location and each product type over YTD. The 2nd tab
is my data tab, which is data imported from our mainframe system. The
data returned lists a branch code, the product type and the totals for
that type, but leaves out any null values (so 3 columns). Branch 0
might have 5 products, Branch 2 might have 2, etc.

My problem is that when I go to refresh the YTD data at the beginning
of a new month, the position of the data changes, so I can't do a
simple cell = !dataA1 formula, b/c the number will probably change to
the wrong product type if a once null value becomes ummm... not null?

What i would like to do is some sort of if function, but I might be co
mingling my excel and SQL formulas a bit. I want to say =IF(!dataA1=0
AND !dataB1=SD-FREE THEN return data in !dataC1). I don't see how that
would work though, b/c I'd have to have multiple formulas in a cell,
and I know that isn't easy, if not impossible.

help?


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=496451