Excel: Find first number in column using match/index function


Hello, Can someone pls. assist me with providing a formula, ideally using the index/match functions, to locate the first absolute (may have positive or negative values) number in a column? I have added snapshots of how the data would look on the two sheets they are currently located on. Thank you in advance. Sheet 1

ID Value
12345678A NULL
12345678A 100
12345678A 150
12345678B 200
Sheet2
ID Expected Result
12345678A 100


This question generated 28 answers. To proceed to the answers, click here.

This thread is current as of June 03, 2014.


For more resources for Microsoft Excel