i have 2 columns and 10 rows. the first column has data in it (1a,2a,3a ... 1b,2b,3b...) the second column has a true or false value. i only have 1 true value and all the rest will be false when changing data.
i want whenever a cell is true to show the value of the true cell in a different cell.
the "TRUE" value will be variable in the column.
If you want a "left lookup", i.e. to make this work without swapping columns, you can use INDEX/MATCH
like this
=INDEX(A:A,MATCH(TRUE,B:B,0))
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments