EXCEL DATA VALIDATION

Below are a series of excel formulas that can be used to create dependent lists for data validation.
=INDIRECT("CustTable[Customers]")
OR
=INDEX(CustTable[Customers],1):INDEX(CustTable[Customers],COUNTA(CustTable[Customers]))
=IF(OR('Invoice Register'!$D22="Choose…",'Invoice Register'!$D22=""),"",INDEX(CustTable,1,MATCH('Invoice Register'!$D22,CustTable[#Headers],0)):INDEX(CustTable,COUNTA(INDEX(CustTable,,MATCH('Invoice Register'!$D22,CustTable[#Headers],0))),MATCH('Invoice Register'!$D22,CustTable[#Headers],0)))

Leave a Reply


*