Data Validation

[Mohtishim]

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)))))))))))))))))

 

[pgc01]

Hi Mohtishim
Welcome to the board

Instead of all the ifs, write the names of all the people in a range and use a match.

For ex., write the names in Z6:Z22 and use the formula:

=INDEX(Database!$C$6:$G$22,MATCH($D$6,$Z$6:$Z$22,0),0)

 

[Mohtishim]

Bundle of Thanks pgc01, it is working now and the problem has been solved.
Regards,

Mohtishim

Hi Mohtishim
Welcome to the board

Instead of all the ifs, write the names of all the people in a range and use a match.

For ex., write the names in Z6:Z22 and use the formula:

=INDEX(Database!$C$6:$G$22,MATCH($D$6,$Z$6:$Z$22,0),0)

 

[pgc01]

You're welcome. Thanks for the feedback.