Find last value

B

Brisbane Rob

Hi

Column A has the month's dates which includes weekends.
Column B has a lookup formula with the lookup being the date, which
brings in values from another spreadsheet. There are only seldom values
brough in over weekends.
Column C has a daily budget

How do I find the date against which the last data was brought in by
the lookup?

Hope I was clear enough.

Thanks for your help. guys.
 
B

Brisbane Rob

Hi Bob

The date is used to get the data from a corresponding date in another
spreadsheet. i.e. 1/20/06 will get a value from spreadsheet B which
also has dates for the month.

Thanks
 
B

Bob Phillips

Do you mean something like

=INDEX('Sheet B'!$A$1:$A$1000,MATCH(MAX('Sheet A'!B1:B200),'Sheet
B'!$B$1:$B$1000,0))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brisbane Rob" <[email protected]>
wrote in message
news:[email protected]...
 
B

Brisbane Rob

No, Bob, I didn't explain myself well. If you have two colomns of data,
column A containing date values, and column B containing a lookup
formula, what formula can you use to find the last cell in column B
that contains a value, bearing in mind that there will be gaps in
column B (corresponding to the weekends)

Hope that's clearer.
 
B

Brisbane Rob

Thanks Bob, that seems to have done the trick. Now all I have to work
out is how to read the date in the column to its left!

Much appreciated
 
Top