How to copy first blank cell in a range to another cell

I want to copy the numerical value of the first non-blank cell to another cell. For example:

I want to copy the value of the first non-blank cell in the range (A5:A15) to cell A1
A5 to A10 are blank, but A11:A15 have numerical values. I want to copy the value from A11 to A1

Is there a function or formula that will do that? For example:

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

With your data in B:G, try this...

	A	B	C	D	E	F	G	H	I
2	jan	jan aa	jan bb	jan cc	jan dd	jan ee	jan ff		jan aa
3	feb		feb aa	feb bb	feb cc	feb dd	feb ee		feb aa
4	mar			mar aa	mar bb	mar cc	mar dd		mar aa
5	apr				apr aa	apr bb	apr cc		apr aa
6	may					may aa	may bb		may aa
7	jun						jun aa		jun aa
8	jul	jul aa	jul bb	jul cc	jul dd	jul ee	jul ff		jul aa
9	aug		aug aa	aug bb	aug cc	aug dd	aug ee		aug aa
10	sep			sep aa	sep bb	sep cc	sep dd		sep aa
11	oct				oct aa	oct bb	oct cc		oct aa
12	nov					nov aa	nov bb		nov aa
13	dec						dec aa		dec aa

I2=INDEX($B2:$G2,MATCH(TRUE,INDEX(($B2:$G2<>0),0),0))
copied down