When using Vlookup
Example:

A B
1 5
2 6
3 7
4 8
5 9
If I use vlookup(2.7,a,2,true) I get 6. but i need the average between 6 and 7 (i.e. (6+7)/2=6.5)
Can this be done?
Thank you.