This will get the cell value below the matched value in F1:K1

=OFFSET(INDEX(F1:K1,MATCH(value,F1:K1,0)),1,0)

You could also use

=INDEX(F2:K2,MATCH(value,F1:K1,0))

without OFFSET

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"David B" wrote in message
...
Don,

Thanks for the reply...

I get the Match function to work, but don't know how to use "offset" based
on the result I get from "Match"

"Don Guillett" wrote:

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