Formula - possibly Vlookup

[Miloni]

I have the database in the following manner :

Sheet 1
Frequency : 5 (can change)

Col X Col Y Col AA Col AB
Roll #'s Density Roll #'s Density
1 0.079 20 0.123
5 0.952 25 0.456
10 0.910 30 0.789
15 0.927 35 0.012

Sheet 2
Output should come out as follows :

Roll #'s Density
1 0.079
2 0.079
3 0.079
4 0.079
5 0.952
6 0.952
7 0.952
8 0.952
9 0.952
10 0.910
11 0.910
12 0.910
13 0.910
14 0.910
15 0.927
16 0.927
17 0.927
18 0.927
19 0.927
20 0.123
21 0.123
22 0.123
23 0.123
24 0.123
25 0.456
26 0.456
27 0.456
28 0.456
29 0.456
30 0.789
31 0.789
32 0.789
33 0.789
34 0.789
35 0.012

The frequency of the roll numbers can change. How can I have excel do this ?

Any help appreciated

 

[Gerald Higgins]

This would probably be easier if instead of this
Col X Col Y Col AA Col AB
Roll #'s Density Roll #'s Density
1 0.079 20 0.123
5 0.952 25 0.456
10 0.910 30 0.789
15 0.927 35 0.012

you had this...

Col X Col Y
Roll #'s Density
1 0.079
5 0.952
10 0.910
15 0.927
20 0.123
25 0.456
30 0.789
35 0.012

Is this an option for you ?

 

[Miloni]

Thanks for looking into it. Unfortunately, this is not an option. But I did try to figure a way out using vlookup based on multiple tables. Let's see if it works.