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

If you have your data where you want to find the lowest value in C1:C20 and the data you want something returned from in A1:A20 then try the following formula:

=INDEX($A$1:$A$20,MATCH(MIN($C$1:$C$20),$C$1:$C$20 ,0))

Sorry, I don't mean the lowest value numerically, (41352454346) but the lowest/bottom (41352454346) in a list?

If you have your numbers in A1:A100 then

Last value: =LOOKUP(2,1/(A1:A100<>""),A1:A100)

Address of last value: =ADDRESS(MATCH(9.9E+307,A:A),1,4)