VLOOKUP HELP for a variable that is not there, and want to s

[chukwa]

Open High Low Close Volume
7-Nov-05 2.38 2.4 2.37 2.39 13766000
4-Nov-05 2.36 2.4 2.36 2.38 20478000
2-Nov-05 2.34 2.37 2.33 2.37 30224000
1-Nov-05 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
31-Oct-05 2.34 2.35 2.33 2.33 23715000

where the formual equals =VLOOKUP($A7,singtel!$A:$M,2,FALSE)

where the vlookup is looking up the date on another spreadsheet

in this case 1 nov 05 was a holiday and i want the cell to be referenced to the 31st oct

how do i change my formula to adjust for this

 

[just_jon]

If your data is sorted you can change the 4th argument to TRUE.