Re: Offsetting the Rows of a VLookup Result

Tech-Archive recommends: Fix windows errors by optimizing your registry

Assuming that you wish to return the corresponding value in Column K,
try...

=INDEX('Results Table'!A9:K24,MATCH(Gauge!A8,'Results
Table'!A9:A24,0)+1,11)

To return the corresponding value of another column, change the third
argument of INDEX accordingly. For example, to return the corresponding
value in Column C, change 11 to 3.

Hope this helps!

In article <7428F12C-2065-452D-92C5-4583E8D65387@xxxxxxxxxxxxx>,
"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> I have a two work*** Excel file
> "Gauge" is a summary work*** of the "Results Table" work***.
>
> I have measures numbered on each work*** (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.
.

Quantcast