Hi,
Is there a way of performing the formula below but without the AND or replacing it with an index formula?
=IF(AND($D$26=1,$B$36=1),Mapping!$I13,IF(AND($D$26=1,$B$36=2),Mapping!$N13,IF(AND($D$26=1,$B$36=3),Mapping!$O13,IF(AND($D$26=1,$B$36=4),Mapping!$P13))))
Thanks!
Bookmarks