How can I pull a value from one column based on the values of another column?

Web Applications Asked by William Pratt on December 4, 2020

When the value in the “Amount Owed” column becomes less than 0, I want the value in the “Year” column to appear under “Year Paid Off.”

For example, if the “Amount Owed” dropped below zero at “Year” 1, I would want 1 to appear under “Year Paid Off”

I’ve tried a few different ways but nothing seems to work. I thought I could just do something like =if(f6:f130<0,c6:c130) but that seems way off.

One Answer

if there will be only one possible negative value try this:

E2: =FILTER(C6:C130;F6:F130 <0)

if there will be more the one possible negative values try this:

E2: =TRANSPOSE(FILTER(C6:C130;F6:F130 <0))

enter image description here

Answered by user0 on December 4, 2020

Add your own answers!

Related Questions

Redirect Google search to YouTube in one click

1  Asked on December 5, 2020 by yoann


How can I wrap text in a text box in

3  Asked on November 13, 2020 by daniel-williams


Export full revision history of Google Doc

0  Asked on September 15, 2020 by lysander


MS teams bot to add people to group chats

0  Asked on September 2, 2020 by user254126


How to set a cell is a formula equal to another cell?

1  Asked on August 20, 2020 by romulus-urakagi-tsai


Create and link new Google document in one step

1  Asked on August 2, 2020 by michael


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir