Identify values in a specific column and list them on another column!! PLEASE HELP!

[Shawez]

Book1.xlsx



So this is what my cells look like but only in the hundreds of thousands of rows! So i need to scan the columns and see where there are numbers (release numbers). When I find the release numbers, i want them to be reported back (copy-pasted) into the 'Release' column. Now this is where this gets tricky! Ok once I get the release data into the release column, I need that heading of the column to be reported back to the 'Product'.

For example:
If i start scanning the first row. The MBG has a reportable 'Release' version. So this gets reported back to the 'Release' column and the heading of this column - 'MBG' in this case gets copied to the 'Product column'!!!

Any ideas??

[ron2k_1]

Will there be any instance where you'd have version numbers in more than one cell in the same row?

[ron2k_1]

Here is the long way, assuming you don't have more columns that those you showed on your example, and that no more than 1 version number will appear per row:
Enter on A2:

=INDEX($C$1:$I$1,,MATCH(B2,C2:I2,0))

Enter on B2 (Sorry for the long formula, I'm not that good with arrays):

=IF(ISNUMBER(VALUE(LEFT(C2,1))),C2,IF(ISNUMBER(VALUE(LEFT(D2,1))),D2,IF(ISNUMBER(VALUE(LEFT(E2,1))),E2,IF(ISNUMBER(VALUE(LEFT(F2,1))),F2,IF(ISNUMBER(VALUE(LEFT(G2,1))),G2,IF(ISNUMBER(VALUE(LEFT(H2,1))),H2,IF(ISNUMBER(VALUE(LEFT(I2,1))),I2,"")))))))

Drag down as needed.

[Shawez]

Thank ron2k_1 but actually there are a ton of other columns than the ones i posted only theyre not really needed until later to identify who the client is. But the version number will be the only one per row!!

[Shawez]

WOW i tweaked it a bit and it worked!!! THANK YOU SO MUCH!!!

[Shawez]

=if(isnumber(value(left(c2,1))),c2,if(isnumber(value(left(d2,1))),d2,if(isnumber(value(left(e2,1))),e2,if(isnumber(value(left(f2,1))),f2,if(isnumber(value(left(g2,1))),g2,if(isnumber(value(left(h2,1))),h2,if(isnumber(value(left(i2,1))),i2,"")))))))