Help with a formula

[NED]

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 ?

 

[davesexcel]

Can anyone help with a formula for the following

I have 2 worksheets in the same spreadsheet and want to be able to i
put a marker in 1 column say letter "A" and return the text containe
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 ou

 

[NED]

That seems to have helped Many thanks