SOLVED: Find first non blank in a range and return cell value in range.

[Lewzerrrr]

SOLVED



I have a huge data source, what I need to do is find the first non blank cell in a range of I5:EG5 (dragged down) and return the value of I3 or L3 or O3...

See below example so i need to get the results that are in N3:N5

[TABLE="width: 840"]
<tbody>[TR]
[TD="class: xl65, width: 56"][/TD]
[TD="class: xl65, width: 56"]A[/TD]
[TD="class: xl65, width: 56"]B[/TD]
[TD="class: xl65, width: 56"]C[/TD]
[TD="class: xl65, width: 56"]D[/TD]
[TD="class: xl65, width: 56"]E[/TD]
[TD="class: xl65, width: 56"]F[/TD]
[TD="class: xl65, width: 56"]G[/TD]
[TD="class: xl65, width: 56"]H[/TD]
[TD="class: xl65, width: 56"]I[/TD]
[TD="class: xl65, width: 56"]J[/TD]
[TD="class: xl65, width: 56"]K[/TD]
[TD="class: xl65, width: 56"]L[/TD]
[TD="class: xl65, width: 56"]M[/TD]
[TD="class: xl65, width: 56"]N[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]Week 1[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"]Week 2[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"]Week 3[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl66"]Week 4[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD="class: xl69"]Units[/TD]
[TD="class: xl69"]Stocks[/TD]
[TD="class: xl69"]Cover[/TD]
[TD="class: xl69"]Units[/TD]
[TD="class: xl69"]Stocks[/TD]
[TD="class: xl69"]Cover[/TD]
[TD="class: xl69"]Units[/TD]
[TD="class: xl69"]Stocks[/TD]
[TD="class: xl69"]Cover[/TD]
[TD="class: xl69"]Units[/TD]
[TD="class: xl69"]Stocks[/TD]
[TD="class: xl69"]Cover[/TD]
[TD="class: xl70, width: 56"]How many weeks in stock[/TD]
[TD="class: xl70, width: 56"]First week of stock[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]20[/TD]
[TD="class: xl69"]20[/TD]
[TD="class: xl69"]20[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"]3[/TD]
[TD="class: xl69"]Week 1[/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl69"]Week 2[/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]10[/TD]
[TD="class: xl69"]2[/TD]
[TD="class: xl69"]Week 3[/TD]
[/TR]
</tbody>[/TABLE]