I'm writing a small vocab game for kids: There r several answers to 1 question n I had them in Sheet 2 where Sheet 1 contains the questions. Participants are required to put their answers in Sheet 1, eg. Cell A1 has the question, and answer is to be entered in Cell A2. In Cell B2, I need a formula to check the answer in Cell A2 against model answer in Sheet 2 (eg. Sheet2!A2:A10) with these criteria: 1) If B2 matches any of the answers in Sheet2!A2:A10, then B2 will show "You're a genius!" 2) Otherwise it will show "Pls try again". 3)If nothing is entered in A2 (ie. blank), then B2 will be blank. Tried creating a formula with "If"+"Match" but it doesn't work. Hope someone can shed some light on this.

Something like this? =IF(A1=Sheet2!A1,"correct","wrong")

Hi rhawk7938, this won't work as the answers range from Sheet2!A1:A10. Thanks for your effort anyway.

Hi Lily How about =if(type(vlookup(a2,sheet2!a2:a10,1,false))=16,"wrong","correct") Cliff

Hi Lilly Forgot the no answer option, try this: =if(a2="","",if(type(vlookup(a2,sheet2!a2:a10,1,false))=16,"wrong","correct")) Cliff

Hi Cliff, Your formula works well. Juz b4 I chk your post, I managed to solve my problem with this: =IF(AND(ISNA(MATCH(A2,Sheet2!A1:A10)=1),A2=""),"",IF(ISNA(MATCH(A2,Sheet2!A1:A10,0)=1),"Wrong","Correct")) Although this formula works too, I think yours is much simpler. Many thnx. Lily.