# [b]Problem with formula[/b]

#### Exceluser987

##### New Member
Hi,

I have a list with an ID number in column A. In column B I have a customer number. See below.

ID Customer number
4 900002
200 900085
1425 900112
1487 900265

The table should look as follows. E.g. All the numbers between ID 4 and ID 200 should have the customer number 900002. This means inserting and copy/paste in that certain range. (Note that the IDs can always change)

ID Customer number
4 900002
5 900002
6 900002
7 900002
... ...
198 900002
199 900002
200 900085
1425 900112
1487 900265

Thanks!

Cheers

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Formula problem

I would like to have a formula to solve this problem

If your ID's started from cell A2 then the formula would be
Code:
``=IF(A2>=4,IF(A2<=200,900002,"Other Customer Number"),"Other Customer Number")``

The example below shows how it would be.

Please note, you can also change the "Other Customer Number" part of the formula to work out other customer numbers by putting another IF formula in.

formula

This is not what I am looking for. The IDs can change and the customer numbers too.

It needs to be completely variable.

Re: formula

Exceluser987 said:
This is not what I am looking for. The IDs can change and the customer numbers too.

It needs to be completely variable.

Did you post this before you saw my suggestion above? If not please try to explain in more detailes.

Replies
23
Views
545
Replies
1
Views
154
Replies
5
Views
249
Replies
15
Views
750
Replies
7
Views
1K

1,203,081
Messages
6,053,416
Members
444,662
Latest member
AaronPMH

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

### Which adblocker are you using?

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

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