Match and Offset

[Kele]

Hi,

I was trying to use lookup to find a value on another sheet then I wanted to Offset to find the value 2 below.

I have been looking it up and i know i cant use look up so i am trying to use Match and offset but i can put them together I have

=MATCH(A10,Pageviews!F5:F12,0) to give the were a10 is on the Pageview sheet

and
=OFFSET(Pageviews!F5,2,0,1) this will give me 2 down but i dont know how to combine them?

this is what i tryed but it give me REF??

=OFFSET(Pageviews!F5(MATCH(A10,Pageviews!F5:F20,0)),2,0,1)

Please help

 

[CodeNinja]

=INDEX(Pageviews!F5:F12,MATCH(A10,Pageviews!F5:F12,0)+2)

 

[Kele]

Thanks so much that works great!!!!