On Tue, 12 May 2009 12:42:02 -0700, Deb
wrote:

I'm wondering if there's a way to have Excel look for a specific value in a
column (e.g. lookup the word "Government" in column A) and then if it finds
that value, to search down to the end of contiguous data following the lookup
value and return the value of the cell on the last row in the third column.

Can this be done?? I feel like it should be possible, but my brain is about
fried tried to figure it out...

Try this formula:

=INDEX(C1:C100,100-MAX(ISBLANK(OFFSET(A1,MATCH("Government",A1:A100,0 ),0,100))*(100-ROW(OFFSET(A1,MATCH("Government",A1:A100,0),0,100) )))-1)

Note: This is an array formula that has to be entered with
CTRL+SHIFT+ENTER rather than just ENTER.

Change the 100 in 7 places to fit the number of rows with data that
you have in columns A:C.

Hope this helps / Lars-Åke