my condition is of the form AND(A1=B1,A1=C1) - thanks Barb and Pete. But -
instead of just one cell per column, I need to look for A1 in ranges
R1B1:R150B1 and R1C1:R150C1, respectively. What function, or construct,
should I use?