Formula - possibly Vlookup

Miloni

Board Regular
Joined
Nov 10, 2008
Messages
103
Office Version
  1. 2007
Platform
  1. Windows
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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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

Board Regular
Joined
Nov 10, 2008
Messages
103
Office Version
  1. 2007
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,141,847
Messages
5,708,950
Members
421,601
Latest member
Garlo

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top