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

NED Wrote:
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 ?
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: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528039

That seems to have helped Many thanks


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