Dazman,

I think that you just want to use =TODAY()-1 instead of =NOW()-1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dazman" wrote in
message ...

Hi,

I have yesterdays date in a spreadsheet which is obtained by the
function =NOW()-1. It's shown on the spreadsheet with a Date and a time
and I didn't want the time so I formatted the cell to only show the
date.

I then want to refer to this Cell with yesterdays date, which is in B2
in my main spreadsheet with a VLOOKUP as follows:
=VLOOKUP(B2,'Historical Funds'!B4:C3000,2)

The info in the Historical Funds sheet looks like this:
A B C
1
2
3
4 05/08/2005 59.11
5 04/08/2005 58.9
6 03/08/2005 58.91

The dates in Column B are UK formatted dates, without the time.

Does anyone know what I have to do to first format my VLOOKUP search
criteria correctly to handle dates? (maybe strip the time?) I know my
Vlookup works, because when I search on simple strings instead of dates
there is no problem getting my values from column C

Any help would be appreciated!


--
dazman
------------------------------------------------------------------------
dazman's Profile:
http://www.excelforum.com/member.php...o&userid=25903
View this thread: http://www.excelforum.com/showthread...hreadid=393542