Vlookup and Roundup combined

[JoeRooney]

Hi ,

I am having problems writing a formula with roundup and VLOOKUP combined and wondering if anyone could help me.

I have a product table that is split into durations of 3 months (Example below). The value of the product always rounds up to a duration of 3, for example if the duration is 1 month the value to be reported is the same as the duration of 3 months, if the duration is 4 months it should be reported the same as the duration of 6 months and so on.

Unique ID	Product Code	Duration	D	AD
12343	1234	3	0.50	0.41
12346	1234	6	0.99	0.81
12349	1234	9	1.49	1.22

At the moment I am using a unique ID to validate the values in a spreadsheet to confirm it matches the product table. What I cant figure out is to add roundup to vlookup so I will still get a value reported if the duration in the spreadsheet does not exist i.e. 8 months duration is not in the product table , If 8 is reported in the spreadsheet I would like the formula to report the value for 9 months.

Any help with this is greatly appreciated

 

[Fluff]

You could use the CEILING function

 

[DanteAmor]

If I understood correctly, do you need something like this?

Book1
	A	B	C	D	E
1	Unique ID	Product Code	Duration	D	AD
2	12343	1234	3	0.5	0.41
3	12346	1234	6	0.99	0.81
4	12349	1234	9	1.49	1.22
5
6
7
8	Duration	D
9	1	0.5
10	2	0.5
11	3	0.5
12	4	0.99
13	5	0.99
14	6	0.99
15	7	1.49
16	8	1.49
17	9	1.49
Hoja2

Cell Formulas
Range	Formula
B9:B17	B9	=VLOOKUP(A9+2,$C$2:$D$4,2,1)