INDEX MATCH OFFSET : Help please

[cyncerq]

Hi There, I have Sheet1 and PerfReport and am trying to add an Index Match formula t column G.

I want column K info. in PerfReport to populate after matching that to column D in Sheet1 to column J in PerfReport

But my issue is I have 4 instances of the same number in column J and after matching I want the column K data from 2 rows below and 1 column over.

=INDEX('PerfReport'!$K:$K,MATCH(D3:D26,'PerfReport'!$J:$J,0),2,1)

I get #VALUE! resuts in column G on Sheet1.

Here is a snapshot


-- removed inline image ---





-- removed inline image ---

 

[cyncerq]

Sorry for the noise from my image mishap:

[url]http://W:\GlassLewisProxyPaper\2014\PerfReport.jpg
http://W:\GlassLewisProxyPaper\2014\Sheet1.jpg[/URL]






Hi There, I have Sheet1 and PerfReport and am trying to add an Index Match formula t column G.

I want column K info. in PerfReport to populate after matching that to column D in Sheet1 to column J in PerfReport

But my issue is I have 4 instances of the same number in column J and after matching I want the column K data from 2 rows below and 1 column over.

=INDEX('PerfReport'!$K:$K,MATCH(D3:D26,'PerfReport'!$J:$J,0),2,1)

I get #VALUE! resuts in column G on Sheet1.