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