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".

tank	code 1	code 2
L001		15.2
L001		15.5
L001	14.1	15.7

<tbody>
</tbody>

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.