vlookup holidays and weekends

[donh]

I need to create a formula using VLOOKUP to search for the appropriate date and return the value for that date. If the date is a weekend or holiday, then the lookup should return the closing value for the previous day.

I know this would be a "if holiday or weekend then -1" but is there a formula for this - - - not sure if networkdays would work here or not.

Thanks

 

[barry houdini]

Try this (revised)

If your VLOOKUP is

=VLOOKUP(A1,B2:C10,2,0)

where A1 is your date then change to

=VLOOKUP(WORKDAY(A1+1,-1,Z1:Z10),B2:C10,2,0)

where Z1:Z10 contains your holiday dates