Please can someone help me with the following query?

If i have a given number and there is a matching number within a row, how
can I return the actual cell ref that the matching number is in please?