I am wanting to compare a new store to existing store performance. Any stores that meet the criteria such as same location, sales within 5%, GP within 10% and size within 10%.
The below formula loads in all store names not just the ones that meet the criteria can someone tell me what I have done wrong in the formula.
[TABLE="width: 161"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 1627"]
<colgroup><col></colgroup><tbody>[TR]
[TD]IFERROR(INDEX(Table1[Store Name],(IF(AND($D$3 - Table1[Retail m2]) <= 10%, IF(AND($D$3 - Table1[Retail m2]) >= 10%, IF(AND($B$3-Table1[Sales])<=5%,IF(AND($B$3-Table1[Sales])>=5%, IF(Table1[Location]= $F$3, IF(AND($E$3 - Table1[Qty Sold Per Day]) <= 10%, IF(AND($F$3 - Table1[Qty Sold Per Day]) >= 10%,))))))))),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
The below formula loads in all store names not just the ones that meet the criteria can someone tell me what I have done wrong in the formula.
[TABLE="width: 161"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 1627"]
<colgroup><col></colgroup><tbody>[TR]
[TD]IFERROR(INDEX(Table1[Store Name],(IF(AND($D$3 - Table1[Retail m2]) <= 10%, IF(AND($D$3 - Table1[Retail m2]) >= 10%, IF(AND($B$3-Table1[Sales])<=5%,IF(AND($B$3-Table1[Sales])>=5%, IF(Table1[Location]= $F$3, IF(AND($E$3 - Table1[Qty Sold Per Day]) <= 10%, IF(AND($F$3 - Table1[Qty Sold Per Day]) >= 10%,))))))))),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>