I am trying to find a formula (or combination of formulas) that I can use to find the lowest cell in a column that has a value in it (is not clear/blank). That is the main problem.

I would like to then take the value of the cell, that is on the row horizontal to the cell found and in the first column. I think I might be able to work this out, using a vlookup function maybe, the main issue is stated in the title and first paragraph.

Thanks,
EddyWD