Excel formula

[nsufferin]

I am tring to set up a wages spreadsheet and print pay slips. On the payslip I need to enter a number (week no) and then the data shown in the payslip needs to show the data which refers to that week in the spreadsheet.(If that makes sence.

 

[Stormseed]

Hi, welcome to MrExcel.

No, that does not make sense. Your question is incomplete and unclear. Please post examples of your problem alongwith your expected results.

 

[nsufferin]

I have in column A a list of numbers 1 to 10
I have in column B a list of numbers eg £31.26, £61.36, £26.45, £39.34 etc.
I want to input into cell c1 a number which is listed in column A and get the corresponding number to appear in cell D1.

A B C D
1 1 £31.26 3 £26.45
2 2 £61.36
3 3 £26.45
4 4 £39.34
5 5 £20.35
Thanks

 

[Stormseed]

See table below and watch out for cell D2 for the formula. Is this what you want:

Book.xls
	A	B	C	D
1	ListofNumbers	Values	ValueIenterwhichisincolA	CorroespondingvaluetocellincolA
2	1	31.26	3	26.45
3	2	61.36
4	3	26.45
5	4	39.34
6	5	20.35
Sheet3

 

[nsufferin]

Absolutely superb!!!!!!!!!
Many Thanks