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