Look Up Help Needed

[Bob]

Let's say I have a data table where the top row contains this month's dates
and the row beneath contains a bank balance. I update the bank balance row
each day with the prior day's balance. Also, there is a column to the far
right called 'Daily Total.' See below:


Daily Total
Dates| 7/1 7/2 7/3 etc.
Value| $1 $4 $5 etc. ?

How can I have the "Daily Total" column return the most recent date's bank
balance? Note, it is possible that the balance could be zero.

 

[Peo Sjoblom]

=INDEX(A2:Z2,MATCH(MAX(A1:Z1),A1:Z1,0))

--


Regards,


Peo Sjoblom

 

[Mike H]

Hi,

Provide you don't have a daily balance in excess of

100000000000000000000000

This should work
=LOOKUP(10^23,A2:AE2)
It will find the right most number in row A2:AE2

Mike

 

[T. Valko]

In other words, you want to return the *last* numeric value of the row?

Try something like this:

=IF(COUNT(A2:AE2),LOOKUP(1E10,A2:AE2),"")