Forum Discussion
Formula to autofill a PO #
I have a workbook with 2 sheets. Sheet 1, column A is where the formula needs to go - based off the information in the sheet called Customer list. Example: Customer List - Column A is customer nam...
=LET(Code,XLOOKUP(B2,'Customer List'!$A$2:$A$17,'Customer List'!$B$2:$B$17,"New Customer"),
Nbr,COUNTIF($B$1:$B1,B2)+1,
PONbr,Code&TEXT(Nbr,"000"),
PONbr
)
Rather than "random", I'd recommend sequential since verifying that a number hasn't already been used would be overly complicated.
- I'm getting an error #NAME?
- It's MS Office Home and Student 2019.
Excel says Version 2406
