I am trying to write a lookup function that will find a row of data for a
specific store (indicated by a store number, i.e. my "lookup value") then
return the data for the row immediately below the specified store's data. (I
also want to create a formula for the store data on the row immediately above)

It seems that the offset function should come into play, but I'm hitting a
wall on how to do this...any help?

Thanks