Excel 2007 : Using VLookup to find multiple values within a STDEV

Hi,

I am using VLOOKUP to match data in one table to thier nearest matches in a second table. What I need is for VLOOKUP to find the nearest 5 values above and below the reference value and produce them. This can be spanned over more than one cell. Is this possible.

See attached workbook

I found an error.

Here is a new workbook.

Thankyou Steve R

Your spreadsheet is doing exactly what I had in mind without even using the VLOOKUP function.

Cheers Mate