Assuming your data in A1:G100
H1: holds criteria

=IF(COUNTIF(A1:G100,H1),H1,"NOT FOUND")


"PeterH" wrote:

I am trying to look a worksheet with several colums, & trying to bring in a
value onto another worksheet if it is in any column. IE don't have to
nominate the column the result should be in.