We have a table of business dates, excluding holidays and weekends, which includes stock closing prices. We have another table with dates and we are trying to find the closing price on the preceeding business day. We have been trying to use the Vlookup function, but it isn't working in all cases. If the prior day is a weekend or holiday, the formula returns an #N/A. It can't find the date in the first table.

Does anyone know a solution to this problem?