I have a set of data generated from a report that lists items and their information. It comes with a associated letter already assigned to each item.

For instance item A is labeled as "A" and then proceeds with about 5 more columns of information as well as several lines. However while the information after the letter label is always in the same place, the size of the information is never the same, it could be 5 columns and 4 rows of information for item A, but item B could contain 6 rows.

I have been generating separate reports based off this information with lookup formulas, however I now am in a situation where I need, say, to find information in the 4th column on the second row of the information for item B, which will never be in the same place on these reports.

I have tried several variances on working with the =offset function inside a lookup, as well as a lookup inside an =offset, and couldn't get it to work. I also tried some =index and =match nesting and couldn't get that either since the neither the placement of the array, nor its size is ever static.

I am hoping maybe someone on here can help. Really i am hoping that there is a way to have a vlookup formula return a result offset a certain number of rows in either direction, but i doubt it will be quite that easy.

Thanks for any help anyone can provide.