A_SIRATIron ContributorAug 02, 2020Auto increment the Invoice number Good day, Please assist me with a formulae to auto increment the Invoice number after looking up the previous value for the specific client. See attached file. Thanks. Invoice Number Lookup and Increment.xlsx11 KB
Subodh_Tiwari_sktneerSilver ContributorAug 02, 2020A_SIRAT Or simply this...In B25=IF(D25=D24,B24,INDEX($B$3:$B$20,MATCH(D25,$D$3:$D$20,0))+1)
