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 c2One way, assuming the checking is to be in the sequence as posted ..

Put in C2:

=IF(A1=quot;quot;,quot;quot;,
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;))))

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;JcRquot; gt; wrote in message
...
gt; If value in cell a1 = value in cell a2 or a3 or a4, then display the value
in
gt; cell b2 in cell c2
gt; If value in cell a1 = value in cell a5 or a6 or a7, then display the value
gt; in cell b5 in cell c2
gt; If value in cell a1 = value in cell a8 or a9, then display the
gt; value in cell b8 in cell c2
gt;
quot;JcRquot; gt; wrote in message
...
gt; If value in cell a1 = value in cell a2 or a3 or a4, then display the value
gt; in
gt; cell b2 in cell c2
gt; If value in cell a1 = value in cell a5 or a6 or a7, then display the value
gt; in cell b5 in cell c2
gt; If value in cell a1 = value in cell a8 or a9, then display the
gt; value in cell b8 in cell 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;)))))

Beege