Mix of non-empty cell range search & left vlookup

[wouZa]

Hi all,

quick question from me:
I am trying to get two outputs:

1) content of first non-empty cell (number) from bottom of column (eg. Range C1:C50) - first non-empty cell is C20 --> "content of C20"
2) content of corresponding cell in same row in other column (e.g. A1:A50) - first non-empty cell in examined range C1:C50 was C20, so now result of that row in range A1:A50, = "content of A20".

Thanks

P

[Tony Valko]

If I understand try these:

For the last (bottom-most) numeric value from the range C1:C50:

=LOOKUP(1E100,C1:C50)

For the corresponding entry from the range A1:A50:

=LOOKUP(1E100,C1:C50,A1:A50)

[wouZa]

PERFECT !

Thx a lot!

[Tony Valko]

You're welcome. Thanks for the feedback!