Can you provide a sample of your data, which includes Column A and about
3 other corresponding columns, along with the expected results?

In article ,
far2rare
wrote:

I would like to search 15 columns on the same sheet for cells containing
numbers. For the searched columns that contain numbers, on a seperate
sheet display the value found in a list in one column and the data from
column A in another column.