sorry mangesh,

the formula i used

=if((A53+1)="","",vlookup(index(f52:f61,(match((a5 3+1),e52:e61,0))),
h52 :i61,2,false)
)

thanks

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=385168