I have a report that I need to pull data from each week. The report has the
same four sales categories, just pulled by different filters.

For example:
Filter 1
Category 1
Category 2
Category 3
Category 4

Filter 2
Category 1
Category 2
Category 3
Category 4

Filter 3
Category 1
Category 2
Category 3
Category 4

I need to pull data from Filter 2, Category 1. The problem is that the
position of the rows change each week. The columns stay the same.

I have used a Match function to tell me the row for Filter 2, but I need to
use that in conjunction with a Vlookup to pull data from the columns next to
Category 1. Any ideas on how to do this?