Hello Masters,
I am trying to put a formula in Data Validation >Setting>List>Source, but it is not accepting more then 255 characters and my formula is a bit lengthy.
Please help me on this I am using this formula,
"=IF(D6="Muhammad Abbas",Database!$C$6:$G$6,IF(D6="Maqbool Ahmed",Database!$C$7:$G$7,IF(D6="Shoaib Shamshad",Database!$C$8:$G$8,IF(D6="Zubair Hussain siddiqui",Database!$C$9:$G$9,IF(D6="ASLAM ABBASI (Extor, Jentin, MSD)",Database!$C$10:$G$10,IF(D6="khurram siraj",Database!$C$11:$G$11,IF(D6="muhammad saqlain",Database!$C$12:$G$12,IF(D6="muhammad naveed",Database!$C$13:$G$13,IF(D6="ghayyur hussain",Database!$C$14:$G$14,IF(D6="hisham khaliq",Database!$C$15:$G$15,IF(D6="usman jamil",Database!$C$16:$G$16,IF(D6="fahad tajammul",Database!$C$17:$G$17,IF(D6="fahad hussain",Database!$C$18:$G$18,IF(D6="abdur rahim",Database!$C$19:$G$19,IF(D6="ghulam murtaza",Database!$C$20:$G$20,IF(D6="irfan ahmad siddiqui",Database!$C$21:$G$21,IF(D6="bilal haider siddiqui",Database!$C$22:$G$22,0)))))))))))))))))
I am trying to put a formula in Data Validation >Setting>List>Source, but it is not accepting more then 255 characters and my formula is a bit lengthy.
Please help me on this I am using this formula,
"=IF(D6="Muhammad Abbas",Database!$C$6:$G$6,IF(D6="Maqbool Ahmed",Database!$C$7:$G$7,IF(D6="Shoaib Shamshad",Database!$C$8:$G$8,IF(D6="Zubair Hussain siddiqui",Database!$C$9:$G$9,IF(D6="ASLAM ABBASI (Extor, Jentin, MSD)",Database!$C$10:$G$10,IF(D6="khurram siraj",Database!$C$11:$G$11,IF(D6="muhammad saqlain",Database!$C$12:$G$12,IF(D6="muhammad naveed",Database!$C$13:$G$13,IF(D6="ghayyur hussain",Database!$C$14:$G$14,IF(D6="hisham khaliq",Database!$C$15:$G$15,IF(D6="usman jamil",Database!$C$16:$G$16,IF(D6="fahad tajammul",Database!$C$17:$G$17,IF(D6="fahad hussain",Database!$C$18:$G$18,IF(D6="abdur rahim",Database!$C$19:$G$19,IF(D6="ghulam murtaza",Database!$C$20:$G$20,IF(D6="irfan ahmad siddiqui",Database!$C$21:$G$21,IF(D6="bilal haider siddiqui",Database!$C$22:$G$22,0)))))))))))))))))