Return Number with -

[noraa]

Hello All,

I need this formula to return a 5 digit number with a - and 2 digits it is matching column A on sheet 2
=IFERROR(MAX(OrderNumb)+1,1)


In Column a It reads 24001-1
24001-2
And continues till the end
I would like it to return 24001-3

I have tried formatting both the Cell a column 2 is formatted as ?????-??also tried #####-## no luck.
Any help would be appreciated no VBA please need the formula.

 

[Sufiyan97]

You're welcome.
Glad we could help.