INDEX/MATCH problem

[Arnebjarne]

Hi!

In J4 I'm trying to figure out a formula.
I'm entering data into J3. Then I need the fomlula to search for that value in the range B3:B900. When that vaule is found (it's allways there) I need the formula to return the value from the cell six rows below the cell whece the match is found.

I've tried every combination of INDEX/MATCH and OFFSET/MATCH, but I'm just getting #REF! or a simpe 0.

Some examples:

Please Login or Register  to view this content.

Any good ideas?

[Sam Capricci]

I would think something like this... =OFFSET(INDEX(B3:B900,MATCH(J3,B3:B900,0)),6,0)
you are finding it with the index match then using the offset to go down six rows.

Oh, and changing the commas to semicolons for your region... =OFFSET(INDEX(B3:B900;MATCH(J3;B3:B900;0));6;0)

[Arnebjarne]

Spot on Sambo kid! Perfecet :-) Tnx!

[Sam Capricci]

You're welcome, glad I could help, AND thank you for the rep!