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.