VLOOKUP - varying the LOOKUP

I have a list of information that I wish to perform a lookup function on. The issue is that the lookup values don't correlate to the data values; I need to return the values that are below and above the lookup value.

for example, if the lookup value is 24 and the data range runs 4,8,31,69; is it possible to perfom a lookup that returns the data for the 8 and the 31?

Thanks in advance

AS

Hi, its not clear what your really after can you supply a sample worksheet?

VLookUp has the capability of returning a closest match, i put this together in cell D1

=IF(ISNA(VLOOKUP(C1,A1:A44,1,TRUE)),"",(VLOOKUP(C1,A1:A44,1,TRUE)))

in column A i had values 2,4,6 etc in C1 i entered a number lets say 23, the value returned is 22 which is the next nearest without exceeding the look up number, the reason that it does this is because the VLookUp formula has TRUE as the range lookup instead of FALSE which will only return an exact match.

Hope this helps!

Regards,
SImon

Thank you both, help from both of you has been utilised and is much appreciated.

AS