If And Formula with Index not Working

[MHExcel]

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.

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%,))))))))),"") <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

<strike></strike>

 

[offthelip]

you have definitely got some of your brackets wrong, just looking at the first bit your "AND" statement is:

AND($D$3 - Table1[Retail m2])

you then have "<=10%" sitting outside the "And" brackets, so that isn't going to work. You have this elsewhere as well and probably other errors. The way I debug long statements like this is to use lots of cells and break each part of the statement down to single statement so that I can get the syntax correct for that little bit. I then cut and paste the formula in to notepad (or any othe text editor) where it is easy to combine them together.