Thanks! When I try Sandy's suggestion, it stops at the first row in the
column. I'm actually trying to search down a column of text for the
'test' value, and operate on numeric values in the same row, different
column. I want to do this on multiple 'test' values, so i don't want
to put the formula on each row, but if that is what I have to do - is
there a way to test for multiple 'test' values within the one forumula?


--
KATYDID
------------------------------------------------------------------------
KATYDID's Profile: http://www.officehelp.in/member.php?userid=5993
View this thread: http://www.officehelp.in/showthread.php?t=1318937

Posted from - http://www.officehelp.in