cell contents returned

[userofexcel]

hey there,

here's the situation:

data range with mixed contents. nemed "Date"
col 1 dates
column 2 numbers

in two separate cells, i wish to add the last entries from wach of the
columns.

i have tried to use the following but it returns #ref, na, name etc.

for the first column
=INDIRECT(ADDRESS(MAX((date<>"")*ROW(Date)),
COLUMN(Date),4))

for the second column:
=INDIRECT(ADDRESS(MAX((Date<>"")*ROW(Date)),
COLUMN(Date)+1,4))


my range has empty cell contents for future use inboth columns, I want
to be able to search the contents of each column, and select that last
cell in the column with data.


thanks

 

[userofexcel]

used the following to solve my question,
reminded of
KISS ( keep it simple St....)


=VLOOKUP(MAX(B1:B30),C1:C30,1)
thanks