count cells down with a number in formula

Hi Guys,

I have two tables, one table has some text the same as the other table. I am using a formula =MATCH(R5;$P$5:$P$500;0) to return me the value as to where the repeat is.

So now I have numbers such as 7, 11, 14 where my text is matched.

So now I need a formula to count down a number of cells to return the value of a cell. such as count 7 down in column s and return that value.

Hope someone can help me.

Thanks.

Can you uplaod example..

but I assume you need index...

something like:

=INDEX(A1:A42;MATCH(B5;$P$5:$P$500;0);1)

Hi,

I am attaching a small example.

Thanks.

Writ this in H5 and extend down...
=IF(G6="";"";INDEX($B$6:$B$16;G6;1))

However, I think you running in cricle and calulating same values all over again...

Thats fantastic. Thanks a lot for your help.