Check the help for the MATCH function, it may fit on what you need.

Miguel.

"sanders" wrote:


Hi,
Is it possible to create a looped function where excel looks down a
list for a (non-numerical) value and then returns the row associated to
it to a different worksheet?


Thanks


--
sanders
------------------------------------------------------------------------
sanders's Profile: http://www.excelforum.com/member.php...o&userid=36745
View this thread: http://www.excelforum.com/showthread...hreadid=565971