Count through a list in packages

I am looking for a specific formula ( I think ).

I have a columme with 15 different cirteria (A,B,C...)They are arranged randomly and this cannot be changed. Each criteria has an individual cost (the costs differ also in-between the criteria).

Now, I have different "data-packages" for each critera.

E.g.: I want to see in a new columme which A are in which data-packages for A. Data-package t1 has the first 2 As (1-2). Data-package t2 has the next 3 As (3-5). Data-package t3 has the next 2 As (6-7).

So in total, all 7 As from row C are considered, starting to count from the top. Basically, we want excel to count down the relevant numbers needed for each data-package, but consider the already used ones.

The problem: I found a “manual” solution for it in columme I.

=+IF(H2<=$G$35;"t1";IF(H2<=$G$37;"t2";IF(H2<=$G$39;"t3";IF(H2<=$G$41;"t4"))))

This shows now the these belowng to data-package "t1" etc. And in columme K

=+IF(G4=1;$E4;0)

so show the costs.

Columme G and H are "help cells".

BUT: There are 15 different criteria and also ~128.000 data sets in total and a great amount of data-packages and I am not sure if excel can handle it and it is a lot of manually work as well. So I need a more simple solution.

I was thinking that there must be a formula which just “counts down” the e.g. but with consideration of the already used ones and give us the mapping of each data-package in a form like row I.

VBA is unfortunately not really an option because the company doesn't allow it.

All help is very much appreciated!!

This is a screenshot of my solution so far