Incorrect result for AND fucntion - HELP!

[vpipalia]

Hi guys!

I'm working on a worksheet which relies on lists to select and distribute items and their values across various divisions. (refer workbook - result sheet)

In column A an item is selected along with a division in column B. The items are in different currencies which are fetched using a vlookup referenced to another sheet.

Now it needs to be calculated how much value of items is assigned to each division and each currency. To do this, I'm using a combination of IF and AND functions to evaluate if the selected division and currency matches and then pull the value.
The sheet enclosed is a simple representation of the setup - the actual sheet is much more complex but premise is the same.

The issue is that if no division is selected in column B, then the AND function evalutes the '0' value of the blank cell in column B to be equal to the division in column G,K and O and enters the value under all 3 divisions. I cant reproduce the problem in the attached workbook but still gives the error in the original even though the formulas are exactly the same.

=IF(AND($B3=$G$1,$D3=G$2),$C3,"-")

[Kaper]

Are you sure it's because of no company selected? Or rather because of column C being empty?
If there is an empty cell, it is treated by excel as 0. You may use for instance:

Please Login or Register  to view this content.

to deal with it.

If that's not the case please do a copy of your real file, delete MOST of the data, replace delicate data with dummy values and attach such prepared file