You could try the below

Just change the range to your range. Also if the target changes then
change "3/12" to a cell address

=INDIRECT(ADDRESS(ROW(*J1:J13*)+MATCH("3/12",*J1:J13*,0)-1,COLUMN(*J1:J13*)))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568114