Return values from other rows for column which shows TRUE value in row.

**dbl_dbl** · 10-24-2019, 09:34 AM

So I am looking to to find which column has a TRUE value for a given row, then return information for the column from other rows. It feels like an index/match turned sideways, to me.

In the sample, I was to return the Type from row 1, and the Output from row 2. I've typed in the expected values, but there is no formula in those columns atm.

This feels like it should be easy but for some reason I am struggling. Thanks

**Special-K** · 10-24-2019, 10:02 AM

It is INDEX/MATCH
MATCH to return the column number and then an INDEX on that from row 1 and 2

in F3
=INDEX(A$1:E$1,1,MATCH(TRUE,A3:E3,0))
in G3
=INDEX(A$2:E$2,1,MATCH(TRUE,A3:E3,0))

and copy these formulas down the columns

Return values from other rows for column which shows TRUE value in row.

LinkBack

Thread Tools

Rate This Thread

Display

Return values from other rows for column which shows TRUE value in row.

Re: Return values from other rows for column which shows TRUE value in row.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula shows as True, should shows as False

Lookup value in a list and return True if all values are true, otherwise false

Return distinct values from column where if statement is true

If two cells contain any values then return TRUE

Return Values in of Cells in a Column where Two Other Values in Corr. Rows Match Criteria

Function to search Column for a range of values and return TRUE or FALSE

if multiple values same/others different, return true

Bookmarks

Bookmarks

Posting Permissions