# Formula - possibly Vlookup

#### Miloni

##### Board Regular
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

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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

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 ?

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.

Replies
1
Views
296
Replies
4
Views
535
Replies
3
Views
249
Replies
1
Views
321
Replies
1
Views
157

1,221,507
Messages
6,160,216
Members
451,630
Latest member
zxhathust

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