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.


--
far2rare
------------------------------------------------------------------------
far2rare's Profile: http://www.excelforum.com/member.php...o&userid=35933
View this thread: http://www.excelforum.com/showthread...hreadid=557260

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.

I've uploaded a screenshot of the raw data and the desired results. The
top table is the raw data, the lower table shows what I need. Thanks
for your help!


+-------------------------------------------------------------------+
|Filename: sample.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4961 |
+-------------------------------------------------------------------+

--
far2rare
------------------------------------------------------------------------
far2rare's Profile: http://www.excelforum.com/member.php...o&userid=35933
View this thread: http://www.excelforum.com/showthread...hreadid=557260

Will there always be only one number for any row/set? Or you can you
have more than one number?

In article ,
far2rare
wrote:

I've uploaded a screenshot of the raw data and the desired results. The
top table is the raw data, the lower table shows what I need. Thanks
for your help!


+-------------------------------------------------------------------+
|Filename: sample.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4961 |
+-------------------------------------------------------------------+

There will only ever be one number for each row as shown, thanks!


--
far2rare
------------------------------------------------------------------------
far2rare's Profile: http://www.excelforum.com/member.php...o&userid=35933
View this thread: http://www.excelforum.com/showthread...hreadid=557260

Try...

A29, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(ROWS($A$29:A29)<=COUNT($C$5:$E$20),INDEX($A$5: $A$20,SMALL(IF($C$5:$E$
20<"",ROW($C$5:$E$20)-ROW($C$5)+1),ROWS($A$29:A29))),"")

B29, confirmed with just ENTER, and copied down:

=IF(A29<"",SUM(INDEX($C$5:$E$20,MATCH(A29,$A$5:$A $20,0),0)),"")

Hope this helps!

In article ,
far2rare
wrote:

There will only ever be one number for each row as shown, thanks!