software

If value in cell a1 = value in cell a2 or a3 or a4, then display the value in
cell b2 in cell c2
If value in cell a1 = value in cell a5 or a6 or a7, then display the value
in cell b5 in cell c2
If value in cell a1 = value in cell a8 or a9, then display the
value in cell b8 in cell c2JcR wrote:

in C2:
=IF(OR(A1=A2,A1=A3,A1=A4),B2,IF(OR(A1=A5,A1=A6,A1= A7),B5,IF(OR(A1=A8,A1=A9),B8,quot;quot;)))
Thanks Paul,

This works. Is there any way to shorten the equation ?

I have about 1000 values in cells a2 through a1000.

I only have about 10 values in the b column.

In other words, a2 through a100 will = quot;aquot; in column b
and
a101 through a200 will = quot;bquot; in column b
and
a201 through a300 will = quot;cquot; in column b

etc....

Is there any way to

quot;Paul Lautmanquot; wrote:

gt; JcR wrote:
gt;
gt; in C2:
gt; =IF(OR(A1=A2,A1=A3,A1=A4),B2,IF(OR(A1=A5,A1=A6,A1= A7),B5,IF(OR(A1=A8,A1=A9),B8,quot;quot;)))
gt;
gt;
gt;

IF(COUNTIF(A2:A100,A1)gt;0,B2,IF(COUNTIF(A101:A200,A 1)gt;0,B5,IF(COUNTIF(A201:A3
00,A1)gt;0,B8,quot;quot;)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JcRquot; gt; wrote in message
...
gt; Thanks Paul,
gt;
gt; This works. Is there any way to shorten the equation ?
gt;
gt; I have about 1000 values in cells a2 through a1000.
gt;
gt; I only have about 10 values in the b column.
gt;
gt; In other words, a2 through a100 will = quot;aquot; in column b
gt; and
gt; a101 through a200 will = quot;bquot; in column b
gt; and
gt; a201 through a300 will = quot;cquot; in column b
gt;
gt; etc....
gt;
gt; Is there any way to
gt;
gt; quot;Paul Lautmanquot; wrote:
gt;
gt; gt; JcR wrote:
gt; gt;
gt; gt; in C2:
gt; gt;
=IF(OR(A1=A2,A1=A3,A1=A4),B2,IF(OR(A1=A5,A1=A6,A1= A7),B5,IF(OR(A1=A8,A1=A9),
B8,quot;quot;)))
gt; gt;
gt; gt;
gt; gt;