It would help if you gave details of the cell you are trying to look
up (assume this is A1), and the range of cells you are trying to find
a match in (assume this is Sheet2!A6:Z6), but with my assumptions you
could try this:

=IF(ISNA(MATCH(A1,Sheet2!$A$6:$Z$6,0)),0,A1)

Obviously, change the cell and range references to suit your data.

Hope this helps.

Pete

On Nov 24, 12:54*pm, JR wrote:
I want to find/search a specific number in a row of values then return that
value if found to a given cell or otherwise return the value of 0. This may
seem a simple question but I can't seem to find the correct worksheet
function. thanks
JR