I am trying to use offset with a Vlookup in order to return multiple return values for one lookup value from a large list. However it doesn't work.
I recieve a messege saying that there is an error in my formula. Will OFFSET not work referring to a vlookup because it is a function and not a hard reference? Is there any way to do what I described?
I can post an example if you need it. Thank you