Formula help.

[Spraggs]

Hi All,
Could someone please help with the following...
I'm wanting this all in one statement.

IF cell E3=1 then enter =IF(C3="","Correct","Wrong")
IF cell E3=2 then enter =IF(C3=F3,"Correct","Wrong")
IF cell E3=3 then enter =IF(C3=G3,"Correct","Wrong")
IF cell E3=4 then enter =IF(C3=H3,"Correct","Wrong")
IF cell E3=5 then enter =IF(C3=I3,"Correct","Wrong")

Many Thanks Jase

 

[jasonb75]

Something i just realised, there it fails if the content of F3 includes "1", or G3 includes "2", etc..

 

[jasonb75]

Charles, can you see any reason for this to fail?

=CHOOSE(IF(E3=1,C3="",C3=INDEX(F3:I3,E3-1))+1,"Wrong","Correct")

edit: I'll leave it up but forget that one, just had a look at your suggestion and got an idea from it..

=IF(C3=CHOOSE(E3,"",F3,G3,H3,I3),"Correct","Wrong")