Vlookup offset

Hi all,

I am trying to have a VLOOKUP to return a value that will always be 5 rows below the initial VLOOKUP result,

so if my vlookup finds its match in B4, and it returns J4, what I would like to do is return J9, 5 rows below

Any help greatly appreciated

Ragards,

Thanks for the quick reply, I will have to move away from vlookups in the future. That works great, rep added