Can anyone help with a formula for the following

I have 2 worksheets in the same spreadsheet and want to be able to in
put a marker in 1 column say letter "A" and return the text contained
in the next column to the separate work sheet ?


--
NED
------------------------------------------------------------------------
NED's Profile: http://www.excelforum.com/member.php...o&userid=32974
View this thread: http://www.excelforum.com/showthread...hreadid=528039