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