SOLUTION FOUND: INDEX + CORRESP
Many thanks to the friends who tried to solve my problem, but I managed to unwind after a lot of my head, since I had tried to solve this same problem in other worksheets and in more complicated tables with this one, with several entries. The secret of the solution lies in the use of the CORRESP function, because with it, I can find the line in which the smallest area of steel is bigger than the calculated one, simply by using the CORRESPONDENCE TYPE -1 (IS LARGER THAN) , in the last argument of the formula. That way I use this value in the INDEX function, in which I have all my data as an array, the line the value given by CORRESP and the column the value given by the cell linked to the Form Control , in which the gauge is selected by the user, plus 1 unit
DETERMINATION OF THE EFFECTIVE STEEL AREA:
=SEERRO(ÍNDICE($N$5:$T$34;CORRESP(I21;SE(U12=1;$O$5:$O$34;SE(U12=2;$P$5:$P$34;SE(U12=3;$Q$5:$Q$34;SE(U12=4;$R$5:$R$34;SE(U12=5;$S$5:$S$34;SE(U12=6;$T$5:$T$34))))));-1);U12+1);"Selecione uma bitola de aço maior")
In the CORRESP function of this formula, the user chooses a gauge, which corresponds to a linked cell number of the Form Control (Combination Box - Not Controlling ACTIVEX ). Thus, the 4.2mm gauge corresponds to the index 1, 5mm index 2 and so on. This will set the column where CORRESP will search. In the general function INDEX , the last argument of the function that requests the column, where it contains the data I want, is added by a unit, since the gauge chosen by the user corresponds, in the table, to its index plus 1, that is, 4.2mm is index 1, but in table it is column 2, 5mm is index 2, but in table it is column 3 and so on (COLUMN = index + 1) .
The SEERRO function was used in case the largest area of steel in the selected gauge is lower than the calculated one, asking the user to choose a larger gauge.
The CORRESP function returns me, for the values highlighted below, the lines 9 and 13 of the table, respectively.
Ofcourse,thisTableAuxiliarywillnotbeviewedbytheuseraswellasthegaugeselectionindex.IputittobetterunderstandwhatIdid.IchosetheINDEXfunctioninsteadofPROCVbecauseitallowsmetosearchdatatotheleftandthusautomaticallydeterminethebarspacing(Column1),whichisanotherinterestsme.Soweusedthesamefunctionabove,withonlythelastargumentoftheformula,whichisnowColumn1(Spacing).
SPACEDETERMINATION:
=SEERRO(ÍNDICE($N$5:$T$34;CORRESP(I21;SE(U12=1;$O$5:$O$34;SE(U12=2;$P$5:$P$34;SE(U12=3;$Q$5:$Q$34;SE(U12=4;$R$5:$R$34;SE(U12=5;$S$5:$S$34;SE(U12=6;$T$5:$T$34))))));-1);1);"─")
* NOTE: The formulas are great because I have chosen to put the CORRESP formula inside the INDEX formula. But I could have done as I did initially by calculating the CORRESP in another cell and entering the INDEX function with its numeric value only.
