Unfortunately neither of these solutions quite work because the set of
contiguous data isn't constant. The spreadsheet changes monthly and so the
data might be 100 rows one month, but then only 80 rows the next. In
addition, I need to repeat this several times. So for instance, I need to
find "Government" and then return the value from the end of the set of data
that "Government" is found in for column C. After that, I'll need it to find
"AAA" and then return the value from the end of the set of data that "AAA" is
found in for column C, etc.