Excel Game - American States

Hi all,

I'm trying to create a little game for my friends.

Basically, the aim is to guess all the American States.

I have typed all the 50 American States in different cells within Column A (which I will hide). I will be asking them to type the states (In any order) in Column B and when they do so I want Column C to either show "Correct" or "Wrong".

In cell C1 I had the formula =IF(B1=A1-A51,"Correct","Wrong") which does work but only if the participant was to do them in Alphabetical order (which isn't going to happen).

How can I get it to show "correct" in cell C1 if they were to type "New York" in cell B1 when in reality it is actually typed into cell A32 of the hidden column?

Thanks in advance for your help.

Insert a column between A & B. The new column B will say Correct in every row until row 50.
The answers can be inputted into column C. In column D, write a vlookup
=VLOOKUP(C1,$A:$B, 2, 0)

=IF(B1="","",ISERROR(LOOKUP(B1,A:A),"Wrong","Correct"))

Note that this doesn't take into account if they type a duplicate name. That would still return as Correct

Thanks all,

Really appreciate your help!