Excel 2007 Match strings

[wajhansmukh]

HIi

If the number or string is present in B2 on sheet 01 exactly match with the array Q:Q on sheet 02 then the result is “Match found” if not then the result would be “ No Match Found” please let me know what formula will be used in this regards I have tried IF and Exact Function but it’s not working.

Regards

Waj

[teylyn]

one possibility

=if(countif(sheet2!Q:Q,B2)>0,"match found","no match found")