i am trying to automate the numbering with prefix (in column A) but with ifs condition in column K
i have column K with the selection of ("VMS", VMS_FP" and "Patch")
the condition as follows
if VMS, the next numbering should start with VA27
if VMS_FP, the next numbering should start with...