hi,

i may not be very successful in explaining what i need, but here i go:

Col A Col B Col C
10 1A X
20 2B Y
30 2B X

i need to have a formula in a cell on another sheet such that, if the
row contains 1A and X, or 2B and X, i would like (10, 30) to appear as
a result of the formula.

what i mean is:

if sheet2.cell(a1) has the formula '=IF(ColC = "X", ..., ...), the
result in the cell should look like 10, 30.

i have a macro which does this now, but i would like for a formula to
be able to do this in order to obviate the need for a macro.

thanks,

mac.


--
icestationzbra
------------------------------------------------------------------------
icestationzbra's Profile: http://www.excelforum.com/member.php...fo&userid=4580
View this thread: http://www.excelforum.com/showthread...hreadid=486171