how can IF statement written in another short formula

[nskatoch]

=if(p1=1,'fa1'!d6,if(p1=2,'fa1'!d7,if(p1=3,'fa1'!d8,if(p1=4,'fa1'!d9,if(p1=5,'fa1'!d10,if(p1=6,'fa1'!d11,if(p1=7,'fa1'!d12,if(p1=8,'fa1'!d13,if(p1=9,'fa1'!d14,if(p1=10,'fa1'!d15,if(p1=11,'fa1'!d16,if(p1=12,'fa1'!d17,if(p1=13,'fa1'!d18,if(p1=14,'fa1'!d19,if(p1=15,'fa1'!d20,if(p1=16,'fa1'!d21,if(p1=17,'fa1'!d22,if(p1=18,'fa1'!d23,if(p1=19,'fa1'!d24,if(p1=20,'fa1'!d25,if(p1=21,'fa1'!d26,if(p1=22,'fa1'!d27,if(p1=23,'fa1'!d28,if(p1=24,'fa1'!d29,if(p1=25,'fa1'!d30,if(p1=26,'fa1'!d31,if(p1=27,'fa1'!d32,if(p1=28,'fa1'!d33,if(p1=29,'fa1'!d34,if(p1=30,'fa1'!d35,if(p1=31,'fa1'!d36,if(p1=32,'fa1'!d37,if(p1=33,'fa1'!d38,if(p1=34,'fa1'!d39,if(p1=35,'fa1'!d40,if(p1=36,'fa1'!d41,if(p1=37,'fa1'!d42,if(p1=38,'fa1'!d43,if(p1=39,'fa1'!d44,if(p1=40,'fa1'!d45,if(p1=41,'fa1'!d46,if(p1=42,'fa1'!d47,if(p1=43,'fa1'!d48,if(p1=44,'fa1'!d49,if(p1=45,'fa1'!d50,if(p1=46,'fa1'!d51,if(p1=47,'fa1'!d52,if(p1=48,'fa1'!d53,if(p1=49,'fa1'!d54,if(p1=50,'fa1'!d55," "))))))))))))))))))))))))))))))))))))))))))))))))))

 

[Norie]

Try this.

=INDEX('fa1'!D6:D55, P1,1)

 

[nskatoch]

Thanks.