Thread
:
Vlookup and offset function?
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
David B
external usenet poster
Posts: 32
Vlookup and offset function?
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
Reply With Quote
David B
View Public Profile
Find all posts by David B