Offsetting the Rows of a VLookup Result

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 <[email protected]>,
"John" <[email protected]> wrote:

> 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.

Domenic, off topic, do me a favor, take a look at my post from earlier this
afternoon about #N/A.

Biff

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> "John" <[email protected]> wrote:
>
>> 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.

In article <[email protected]>,
"Biff" <[email protected]> wrote:

> Domenic, off topic, do me a favor, take a look at my post from earlier this
> afternoon about #N/A.
>
> Biff

See your post...

Got it. Thanks!

Biff

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> In article <[email protected]>,
> "Biff" <[email protected]> wrote:
>
>> Domenic, off topic, do me a favor, take a look at my post from earlier
>> this
>> afternoon about #N/A.
>>
>> Biff
>
> See your post...

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 <[email protected]>,
"John" <[email protected]> wrote:

> 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.

Domenic, off topic, do me a favor, take a look at my post from earlier this
afternoon about #N/A.

Biff

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> "John" <[email protected]> wrote:
>
>> 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.

In article <[email protected]>,
"Biff" <[email protected]> wrote:

> Domenic, off topic, do me a favor, take a look at my post from earlier this
> afternoon about #N/A.
>
> Biff

See your post...

Got it. Thanks!

Biff

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> In article <[email protected]>,
> "Biff" <[email protected]> wrote:
>
>> Domenic, off topic, do me a favor, take a look at my post from earlier
>> this
>> afternoon about #N/A.
>>
>> Biff
>
> See your post...

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.

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 <[email protected]>,
"John" <[email protected]> wrote:

> 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.

Domenic, off topic, do me a favor, take a look at my post from earlier this
afternoon about #N/A.

Biff

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> "John" <[email protected]> wrote:
>
>> 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.

In article <[email protected]>,
"Biff" <[email protected]> wrote:

> Domenic, off topic, do me a favor, take a look at my post from earlier this
> afternoon about #N/A.
>
> Biff

See your post...

Got it. Thanks!

Biff

"Domenic" <[email protected]> wrote in message
news:[email protected]...
> In article <[email protected]>,
> "Biff" <[email protected]> wrote:
>
>> Domenic, off topic, do me a favor, take a look at my post from earlier
>> this
>> afternoon about #N/A.
>>
>> Biff
>
> See your post...