Skip,
My apologies. What you suggested did work; brilliantly. I had a typo somewhere in the convoluted statement, which now reads:
=INDEX(OFFSET(INDIRECT(G7),0,4,ROWS(INDIRECT(G7)),1),MATCH(F7,OFFSET(INDIRECT(G7),0,2,ROWS(INDIRECT(G7)),1),-1))
Many, many thanks for your help.