I have information in an Excel spreadsheet with 3 columns. The first column contains the value of the first data in a range, with the second column containing the end value of the data range. The third column shows a percentage rate applicable to all values within the range:

IC.0.C00122.0.0.0.0 IC.0.C00125.0.0.0.0 15%
IC.0.C00128.0.0.0.0 IC.0.C00130.0.0.0.0 100%
IC.0.F00122.0.0.0.0 IC.0.F00125.0.0.0.0 15%
IC.0.F00128.0.0.0.0 IC.0.F00130.0.0.0.0 100%
IC.0.P00122.0.0.0.0 IC.0.P00125.0.0.0.0 100%
IC.0.P00128.0.0.0.0 IC.0.P00130.0.0.0.0 100%
IC.0.PE0122.0.0.0.0 IC.0.PE00125.0.0.0.0 100%
IC.0.PE0128.0.0.0.0 IC.0.PE00130.0.0.0.0 100%

So, in Row 1, the 15% rate will apply to C00122, C00123, C00124 and C00125;
In Row 2, 100% will apply to C00128, C00129, and C00130

NOTE - there is a gap between the end value at Column 2 in Row 1 and the start value in Column 1 of Row 2. The (invisible) intervening range, C00126 and C00127, will default to a (invisible) percentage rate of 0%.

The same applies to the data which starts with other letters such as F, P or PE as shown above.

I have a separate list of just data such as:

C00122
C00123
C00124
C00125
C00126
C00127
C00128
C00129
C00130
C00131
Repeated for the data starting with F, P, PE etc

Is it possible to use a formula (some sort of VLOOKUP?) in Column 2 of this separate list to look at the appropriate string of data in the 3 column spreadsheet and pick up the data shown in column 3 [including the data not shown therein (i.e. the 0% allocated to the "invisible" ranges between the ranges shown)]?

The desired end result would be:

C00122 15%
C00123 15%
C00124 15%
C00125 15%
C00126 0%
C00127 0%
C00128 100%
C00129 100%
C00130 100%
C00131 0%
et seq for the other data starting with F, P, PE etc

Thank you for any help you can offer.