Any open office experts? I have a sheet with 4 columns. What I need is a formula that will compare the value in column 3 and 4 to column 1, and return the value in column 2 in the same row as column 1.
This formula returns 'TRUE': =IF(COUNTIF(A1:A5000;D1)OR(COUNTIF(A1:A5000;E1))) Any ideas? Russell Johnson [email protected] _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
