Hi,
I've been trying to use Vlookup, Choose/Match, Index/Match and even Index/Indirect, but I'm unable to get everything to come together correctly, and an hoping someone can help.
I have 10 charts with name ranges over 4 sheets that all have the same # of columns. There are a total of about 45 rows, and each row has an IF, AND, or OR formula to identify if it's true or false (displaying as 1,0) and each row is unique so there is only be one true throughout all the tables at a time based on various factors.
Now that the rows are all calculating, I need to pull only the row or columns from the table that is marked true or 1, and I need to put in a fail safe that will cause it to identify if there is more than 1 row indicating true.
=VLOOKUP(TRUE,B17:G26,2,0) works just fine for each individual table, but I can't find a way to look at all the tables on all the sheets to return the one result I need.
Any suggestions? Anything will help at this point.
Thanks
I've been trying to use Vlookup, Choose/Match, Index/Match and even Index/Indirect, but I'm unable to get everything to come together correctly, and an hoping someone can help.
I have 10 charts with name ranges over 4 sheets that all have the same # of columns. There are a total of about 45 rows, and each row has an IF, AND, or OR formula to identify if it's true or false (displaying as 1,0) and each row is unique so there is only be one true throughout all the tables at a time based on various factors.
Now that the rows are all calculating, I need to pull only the row or columns from the table that is marked true or 1, and I need to put in a fail safe that will cause it to identify if there is more than 1 row indicating true.
=VLOOKUP(TRUE,B17:G26,2,0) works just fine for each individual table, but I can't find a way to look at all the tables on all the sheets to return the one result I need.
Any suggestions? Anything will help at this point.
Thanks