Back Again - I tried your formula in a new spreadsheet to see how it worked,
and it worked great, but when I inserted it into my actual spreadsheet, it's
not working. The range of cells/data the formula refers to are from cells
that have been calculated. Is this the problem? I may not be clear in my
explanation. --
JR


"Pete_UK" wrote:

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