I have an array of data. I want to use a lookup function to find a
particular value, then produce the value directly below this reference. For
example if I'm looking for the value in A4 I want A5 returned. Since the
data is irregular HLOOKUP will not work because the value I'm searching for
is not in the top row. Vlookup returns the cell to the right of my value,
but not below. I've tried the offest function but can't seem to make it
happen. Any ideas?