Vlookup & offset

I have a large table that I want to find the results of cells above or below a selected cell after matching the cell in a vlookup formula. EG - Vlookup finds the cell and returns the result. In a diffrent part of the spreadsheet I now what to display the cells above or below the cell found in the array

For some reason, I couldn't get this to work with vlookup, however it does work with Index/Match.

I've attached a sample zip below. Let me know if it does what you want.

Thanks but this is where i am struggling with the use of offset.
Maybe this will help to explain
I have 16 rows of names in first column and 16 values next to them
In a different table i find the highest number out of the 16 values above and then in the next cell lookup the table above and match the name to the highest number.

Now I want to find the three names immediately above the name in the cell that matches the highest number.
table A1:b16

in a20 highest number is in b13
in b20 name is now a13
in b21 I want to have the result that is immediately above a13 in the table (a12)
in b22 the result two above a13 (a11)
and in b23 the result three above a13 (a10)

thanks for your help

Thanks BigBas it works a treat. I had to copy your formula and change it to suit as every time I created the formula from fresh I kept getting an error.
Many thanks

I'm glad you were able to work with it. Obviously, wed have different data sets, so I would expect that you would have to change it.