How to find the Value form the table comparing

ajmal_pottekattil_yoousuf 

In general you may combine calculations with LET/LAMBDA without helper columns

using

coeff = LAMBDA(unit, par,
    LET(
        range, IF(par="V", VoltageUnits, FrequencyUnits),
        XLOOKUP(
            unit,
            CHOOSECOLS(range, 1),
            CHOOSECOLS( range, 2)
        )
) );

cmcOne=LAMBDA(input,
LET(
    v,       INDEX(input,1,1)*coeff(INDEX(input,1,2), "V"),
    Hz,      INDEX(input,1,3)*coeff(INDEX(input,1,4), "Hz"),
    VolFrom, CHOOSECOLS(data,1)*coeff(CHOOSECOLS(data,2), "V"),
    VolTo,   CHOOSECOLS(data,3)*coeff(CHOOSECOLS(data,4), "V"),
    FreqFrom,CHOOSECOLS(data,5)*coeff(CHOOSECOLS(data,6),"Hz"),
    FreqTo,  CHOOSECOLS(data,7)*coeff(CHOOSECOLS(data,8),"Hz"),
    IFERROR(
        TOCOL( CHOOSECOLS(data,9)/ (
        (v >= VolFrom) *
        (v<=VolTo) *
        (Hz >= FreqFrom) *
        (Hz <= FreqTo) ), 3),
        "no such"
    )
));