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

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

Hi

From your description, I would suggest you have a look at VLOOKUP. It will
find a value in a column and return a value from along its row.
Post back with more information if you need any more help.

Andy.

"sanders" wrote in
message ...

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