Paul,

Are you able to upload a sample file showing an example of your source data and a mocked up solution for us to work with.  8-10 records should suffice. 

@alansidman

Hi Alan,

I need to see if any of the numbers in column A appear in columns B to F

Thanks, Paul

@benjamip 

With some trial and error I came up with a rather bulky CF formula applied to B2:F29 (pasted below). I added something in the bottom right-hand corner to test an entry with a number and a text. The formula/rule requires a modern Excel version. I feel there must be a better way, though it seems to work. Included the rule in your workbook, attached. The formula itself is also in H2 to demonstrate the array of TRUE and FALSE it produces.

=WRAPROWS(
    ISNUMBER(
        XLOOKUP(
            VALUE(
                TEXTBEFORE(
                    TOCOL(B2:F29),
                    " "
                )
            ),
            $A$2:$A$244,
            $A$2:$A$244
        )
    ),
    5
)

@riny 

Thanks Riny, that has worked.