Vlookup and offset function?
If column B contains the value you want to retrieve and A contains the
store codes, how about:
=INDEX(B1:B100,MATCH(code,A1:A100,0)+1)
Does this help?
Kostis Vezerides
David B wrote:
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
|