Hi,

Can I have a shorter formula for this long nested one ?

=IF(I10="",IF(E10="","",IF(E10='2'!J2,'2'!K2,IF(E10='2'!J3,'2'!K3,IF(E10='2'!J4,'2'!K4,IF(E10='2'!J5,'2'!K5,IF(E10='2'!J6,'2'!K6,IF(E10='2'!J7,'2'!K7,IF(E10='2'!J8,'2'!K8,IF(E10='2'!J9,'2'!K9,IF(E10='2'!J10,'2'!K10,IF(E10='2'!J11,'2'!K11,IF(E10='2'!J12,'2'!K12,IF(E10='2'!J13,'2'!K13,IF(E10='2'!J14,'2'!K14,IF(E10='2'!J15,'2'!K15,IF(E10='2'!J16,'2'!K16,IF(E10='2'!J17,'2'!K17,IF(E10='2'!J18,'2'!K18,IF(E10='2'!J19,'2'!K19,IF(E10='2'!J20,'2'!K20,IF(E10='2'!J21,'2'!K21,IF(E10='2'!J22,'2'!K22,"")))))))))))))))))))))),"")

regards

=IF(I10="",IF(E10="","",VLOOKUP(E10,'2'!J2:K22,2,FALSE)),"")

• Marked as answer by drsantoshsinghrathore 14 hours 43 minutes ago

=IF(I10="",IFERROR(VLOOKUP(E10,'2'!$J$2:$K$22,2,FALSE),""),"")

Thank you.

• Marked as answer by drsantoshsinghrathore 14 hours 43 minutes ago
• Unmarked as answer by drsantoshsinghrathore 14 hours 43 minutes ago

Thank you.

=IF(I10="",IF(E10="","",VLOOKUP(E10,'2'!J2:K22,2,FALSE)),"")

• Marked as answer by drsantoshsinghrathore Friday, March 13, 2015 4:42 PM

Thank you.

• Marked as answer by drsantoshsinghrathore Friday, March 13, 2015 4:42 PM
• Unmarked as answer by drsantoshsinghrathore Friday, March 13, 2015 4:42 PM