Use MATCH to find the row and then OFFSET

--
Don Guillett
SalesAid Software

"David B" wrote in message
...
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