try this

put this formula in F2 =IF(HLOOKUP(B2,$C$1:$E$5,ROW(2:2),
0)=1,"ok","error") and drag it down





On Oct 23, 3:24*pm, claude jerry
wrote:
* * *A * * * * * B * * * * * C * * * *D * * * *E * * * *F
1 *Name * *Colour * *Red * * *Blue *Pink * Check Point
2 *Bob * * * *Red * * * 1 * * * * * * * * * * * * * * * ok
3 *Rob * * * *Blue * * * * * * * * *1 * * * * * * * * * *ok
4 *Tom * * * *Pink * * * * * * * * *1 * * * * * * * * * *error
5 * Sam * * * Red * * * * * * * * *1 * * * * * * * * * *Error * * *

User Enters the Following
Name in Col A
Colour in Col B and depending on Which Colour he has entered he will type a
digit in the Colour Col (Col C, D or E)

I want a formula to be entered in Col F, Which tells me if the users have
done it right, "Ok" If its Correct and "Error" if its not correct

E.g in above Sam Selected Colour Red but has entered the Digit in Col D
"Blue" this is wrong. he should enter the digit *in col C Red