first negative- condition that the number in same row in another column is positive

[iamrahul]

hello

I am requesting help to establish a formula to find the first negative in a column subject to the condition that the corresponding number in the same row but in another column is positive.

It will be of great help.

Thank you all ever so much for all your previous helps.

[Glenn Kennedy]

For future reference, it's always easier with a sample sheet (see yellow banner at the top of the page).

=INDEX($A$2:$A$16,MATCH(1,INDEX(($A$2:$A$16<0)*($B$2:$B$16>0),0),0))

[iamrahul]

thank you so so much
yes i am sorry i missed the yellow banner directions
thank you again
regards

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.