software

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 quot;Aquot; and return the text contained
in the next column to the separate work sheet ?--
NED
------------------------------------------------------------------------
NED's Profile: www.excelforum.com/member.php...oamp;userid=32974
View this thread: www.excelforum.com/showthread...hreadid=528039
NED Wrote:
gt; Can anyone help with a formula for the following
gt;
gt; I have 2 worksheets in the same spreadsheet and want to be able to in
gt; put a marker in 1 column say letter quot;Aquot; and return the text contained
gt; in the next column to the separate work sheet ?
lets say in sheet 1
column A
1
2
3
4
column B
a
b
c
d

Sheet 2
Cell B1 enter this formula
=LOOKUP(A1,Sheet1!A1:B4,Sheet1!B1:B4)
in cell A1 enter a number from 1 to 4

hope this example can help you out--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=528039
That seems to have helped Many thanks--
NED
------------------------------------------------------------------------
NED's Profile: www.excelforum.com/member.php...oamp;userid=32974
View this thread: www.excelforum.com/showthread...hreadid=528039