[b]Problem with formula[/b]

[Exceluser987]

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

Can you please help me with the following:

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


Please help!!

Thanks!

Cheers

 

[Exceluser987]

Formula problem

I would like to have a formula to solve this problem

 

[Ste_Moore01]

If your ID's started from cell A2 then the formula would be

=IF(A2>=4,IF(A2<=200,900002,"Other Customer Number"),"Other Customer Number")

The example below shows how it would be.

Book2
	A	B	C	D
1	ID	Customer Number
2	1	Other Customer Number
3	2	Other Customer Number
4	3	Other Customer Number
5	4	900002
6	5	900002
7	6	900002
8	7	900002
9	8	900002
10	9	900002
11	10	900002
12	11	900002
13	12	900002
14	13	900002
15	14	900002
16	15	900002
17	200	900002
18	201	Other Customer Number
Sheet1

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.

 

[fairwinds]

Hi,

Try:

=LOOKUP(D2,$A$2:$B$5)

in E2 and drag down.

Book1
	A	B	C	D	E	F
1	ID	Customer number
2	4	900002		4	900002
3	200	900085		5	900002
4	1 425	900112		6	900002
5	1 487	900265		7	900002
6				8	900002
7				9	900002
8				10	900002
9				11	900002
10				12	900002
11				13	900002
Sheet1

 

[Exceluser987]

formula

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

It needs to be completely variable.

 

[fairwinds]

Re: formula

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.