Column also Row

[Steved]

Hello From Steved

The below Formula gets information from Column 3

=INDEX($A$1:$C$217,MATCH(G4,$A$1:$A$217,FALSE),3)

Can I add to the formula above so that the cell below
will read the above and get the next line down information,
as an example the above looks in Col C the first row and
gets the data, now I want the next row down.
Col A B C
1 01-Jun Tue 19756
2 01-Jun Tue 21789

Thankyou.

 

[Ragdyer]

Try this:

=OFFSET(INDEX($A$1:$C$217,MATCH(G4,$A$1:$A$217,FALSE),3),1,)

 

[Steved]

Thankyou RD I've been trying for a cople off hours to try
and acheive what you have done.

Cheers.