Viking1221
New Member
- Joined
- May 25, 2017
- Messages
- 32
Hello,
My colleagues and I are are stumped on a formula we are trying to build to pull in the correct assumptions based on multiple criteria across rows and columns. I attached a sample spreadsheet of what we are trying to do. We want to pull in the correct number that corresponds to the table. So for this example if we have a dollar $ between the MID and MAX amounts in the columns of $1,100 and a corresponding % variance of 10% (between the -5 and -15%) we want the formula to extract the 35%.
So far all our attempts have failed and we do not want to do this via a macro, but want a formula to do the work.
If anyone has any ideas or knows how to the this please share.
I have a sample version of a file located here: Sample
Thanks
My colleagues and I are are stumped on a formula we are trying to build to pull in the correct assumptions based on multiple criteria across rows and columns. I attached a sample spreadsheet of what we are trying to do. We want to pull in the correct number that corresponds to the table. So for this example if we have a dollar $ between the MID and MAX amounts in the columns of $1,100 and a corresponding % variance of 10% (between the -5 and -15%) we want the formula to extract the 35%.
So far all our attempts have failed and we do not want to do this via a macro, but want a formula to do the work.
If anyone has any ideas or knows how to the this please share.
I have a sample version of a file located here: Sample
Thanks