pinmaster Wrote:
Hi, try this:

in C
=OFFSET(INDEX($A1:$A100,MATCH($D1,$A1:$A100,0)),1, 0)

in E
=OFFSET(INDEX($A1:$A100,MATCH($D1,$A1:$A100,0)),2, 0)

Regards!
JG

Hey, it seems to work great!, thanks alot.


--
Demitre
------------------------------------------------------------------------
Demitre's Profile: http://www.excelforum.com/member.php...o&userid=29720
View this thread: http://www.excelforum.com/showthread...hreadid=495060