All you need to do is use True as the last parameter of Vlookup. When it doesn't
find an entry for the end of the month, it will use the last one available.

--
Regards,
Fred


"Gábor" wrote in message
...
hi,

i have a simple table: in the first column are the dates, in the second are
the exchange rates.
i would like to find the exchange rates of the last day of the months.
the problem is that rates are published only on business days, so for
example in april there is nothing for 30th of april. in this case i should
use the last business day's rate before 30th (28th of April).
could anybody some idea how could i express this in vlookup form? i tried to
use "if" formula, but i couldn't refer to result "#N/A"

thx in advance