# Excel formula

#### nsufferin

##### New Member
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.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
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.

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

See table below and watch out for cell D2 for the formula. Is this what you want:
Book.xls
ABCD
1ListofNumbersValuesValueIenterwhichisincolACorroespondingvaluetocellincolA
2131.26326.45
3261.36
4326.45
5439.34
6520.35
Sheet3

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

Replies
7
Views
640
Replies
1
Views
219
Replies
1
Views
362
Replies
0
Views
802
Replies
1
Views
443

Threads
1,196,113
Messages
6,013,547
Members
441,770
Latest member
Griggsy28

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back