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 c2

One way, assuming the checking is to be in the sequence as posted ..

Put in C2:

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JcR" wrote in message
...
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 c2

"JcR" wrote in message
...
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 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,"")))))

Beege