I have a two worksheet Excel file
"Gauge" is a summary worksheet of the "Results Table" worksheet.

I have measures numbered on each worksheet (e.g. "1.a.1"). I need "Gauge"
cell B8 to lookup (within Results Table cells A9:K24) results for the measure
number listed in cell A8.

The trick is that the performance results are one row below (e.g. the looked
up measure number is in row 9 but the performance results are in row 10). I
cannot place the measure number and the results in the same row (If i could
I'd use Vlookup and not be bugging you.)

I have tried everything - except what works.

Your help is appreciated.