GlennUK said:More clarity please ... does "previous ( or below cell )" mean the next cell down in the lookup table? Or does it mean use the value that the next cell down from where the formula is?
chukwa said: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)
in this case 1 nov 05 was a holiday and i want the cell to be referenced to the 31st oct