Find Non-Blank Cell

[ljybrcd]

I have read some of the other posts, but can't seem to get the suggested formulas to work right. I've tried using vlookup, isblank, index/match, etc.

I have a summary sheet in one tab where I want to lookup a tank number in the first column and get the first non-blank result for that tank number in a column from a table in the second tab.

The First tab is a list of results for each Tank number (Tank in column A, results in columns B and C).
The Second tab is all the results in a large table of data like the example below.
So, I want excel to retrieve the "14.1" result in the "code 1" column for all the rows that match Tank "L001".

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]tank[/TD]
[TD]code 1[/TD]
[TD]code 2[/TD]
[/TR]
[TR]
[TD]L001[/TD]
[TD][/TD]
[TD]15.2[/TD]
[/TR]
[TR]
[TD]L001[/TD]
[TD][/TD]
[TD]15.5[/TD]
[/TR]
[TR]
[TD]L001[/TD]
[TD]14.1[/TD]
[TD]15.7[/TD]
[/TR]
</tbody>[/TABLE]

Thanks!

 

[ljybrcd]

Perfect! Thank you so much for all the help!

 

[Aladin Akyurek]

Perfect! Thank you so much for all the help!

You are welcome.