Actually,

Now that I look at that formula, it doesn't appear to work either. I
have the "pretty" form looking like this:


Prod Type HQ Branch 3 Branch 5 etc....

SD 345 250 200
SD-FREE 1000 700 555
SD-REW 750 500 322
SD-STU 334 225 150

Problem here is that HQ= branches 0, 2, 7, and 2 other alpha branch
codes.

The data sheet looks like this:

Br cd type Aggregate
0 SD-FREE 250
0 SD 100
0 SD-REW 550
0 SD-STU 100
3 SD-FREE 700
3 SD 250
3 SD-REW 500
ETC...

Would it be possible to say, if somewhere in column A = 0 AND somewhere
in column B = SD-FREE, return the cell just to the right of where those
2 values are true?


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