Hello,
I am trying to find the top row value that matches the criteria from three left hand columns and a value in the table. There is a value, an annualized number value, that is used to find the value in the table. The value in the table is to be the closest less than value to that annualized value. Example below:
Specialty of store: Toys
Annualized number: 11
Column a Column b column c column d column e column f
10% 15% 20%
Bread Bakery Baker Head baker 8 10 12
Bread Bakery Baker Assistant 1 6 9 12
Cookie Shop Baker Head baker 4 8 12
Cookie Shop Baker Assistant 1 1 2 3
I am needing to find using the annualized number of "11", the closest less than value in the table using the criteria of "Bread bakery" "Baker" and "Assistant 1", this all needs to give me the percentage in the top row that it corresponds with. Is there a formula for this?
This example should find that "9" is the closest table value, and 15% is the top row number.
Thank you!
I am trying to find the top row value that matches the criteria from three left hand columns and a value in the table. There is a value, an annualized number value, that is used to find the value in the table. The value in the table is to be the closest less than value to that annualized value. Example below:
Specialty of store: Toys
Annualized number: 11
Column a Column b column c column d column e column f
10% 15% 20%
Bread Bakery Baker Head baker 8 10 12
Bread Bakery Baker Assistant 1 6 9 12
Cookie Shop Baker Head baker 4 8 12
Cookie Shop Baker Assistant 1 1 2 3
I am needing to find using the annualized number of "11", the closest less than value in the table using the criteria of "Bread bakery" "Baker" and "Assistant 1", this all needs to give me the percentage in the top row that it corresponds with. Is there a formula for this?
This example should find that "9" is the closest table value, and 15% is the top row number.
Thank you!
