Find/locate the first row with the negative number + extra

Ultimately, I require TRUE OR FALSE.>blockquote

6 columns, values below -- where X has five suboptions types that can :appear (eg. V,W,X,Y,Z)

V 2 3 1 1
Y 2 3 -24 7
Y 1 1 -21 0
X 1 2 -27 2
Z 3 3 -23 -3`

Formula a) firstly locates the row number of the first negative value (-2), the first column from the right; b) using that piece of information pivots identifying which specific type of the five suboptions is actually in place (shall be X).

That's the first bit. Now to the next.

*those above-mentioned suboptions, each one has three of its own attributes; the first one (let's call it ) is a cap the suboption can increment maximum to from 1 -- the second one is a fixed multiplier (m)x() is multiplied by, which results in the additional attribute of the power -- thirdly,

    *     m      pwr         

V 1 9 9
W 2 8 16
X 3 7 21
Y 4 6 24
Z 5 5 25

The purpose is two-fold
c) to firstly confirm what power of the (X) .. &
d) qualify if the predetermined power amount is either =< or > than the negative value in the 2nd column from the right, corresponding to X

V 2 3 1 1
Y 2 3 -24 7
Y 1 1 -21 0
X 1 2 -27 -2
Z 3 3 -23

.. so basicaly, is the number (-27) lower+equal than the X's power of (-24) = TRUE OR FALSE?

All this is just a bit in a larger formula, that I won't bother you with .. what's the (complex?) formula for the above?

• =Also, someone tell me how did I achieve the grey table backlay (* m pwr), to apply to the rest of the post.