Vlookup? help.

[ChuckF]

I am not sure that a vlookup is the way to go, but let me explain what
I am doing. There is an existing spreadsheet that the last column
(furthest right) lists the date of a visit. I need to take that date,
and auto populate it to a seperate spreadsheet.

So, if the last column entered is J, and the value is 2/26/06, I want
that to autopopulate. If though a user enters 3/4/06 in column K, I
want that data instead.

I hope that my question makes sense, and I thank you for your time.

 

[Peo Sjoblom]

You can use

=LOOKUP(MAX(Sheet1!2:2)+1,Sheet1!2:2)

will lookup the last numeric value entered in row 2 of Sheet1

so if 04/01/06 is entered in M2 that will be the result, don't forget to
format as a date


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[ChuckF]

The formula you provided is really close to being perfect.

The problem is that the shee that this data is being pulled from gets
sorted. If both spreadsheets are sorted the same way, this is great.
But they normally won't be.

Any thoughts ?