G
Guest
I have a table of Row = "Invested $" (ie. 10%, 20%...,50%) vs. Column =
"Priority" (ie. 1,2,...,5).
The values are scores and I have a "given value". I want to create a list
or table that shows the Row title (10%) and Column title (1) for all the
values in the table that are greater than the "given value".
I've been trying different ways with INDEX, VLOOKUP and other functions with
no luck yet.
"Priority" (ie. 1,2,...,5).
The values are scores and I have a "given value". I want to create a list
or table that shows the Row title (10%) and Column title (1) for all the
values in the table that are greater than the "given value".
I've been trying different ways with INDEX, VLOOKUP and other functions with
no luck yet.