Formulas to create a numbering based on other cells values

The formula in Z is looking to the formula in X and generates the unique identifier based on the values in columns B, J, and V. Here's a breakdown of the formula:

IF(V5<>"", ...) checks if the value in cell V5 is not empty.
If the condition is true (V5 is not empty), the formula continues to the inner IF statement.
IF(B5="", "", CONCATENATE("CTRI-", VLOOKUP(K5, Clients, 2, FALSE), TEXT(ISOWEEKNUM(J5), "00"), TEXT(ROW($B$4) - ROW(B5), "000"))) checks if the value in cell B5 is empty.
If the condition is true (B5 is empty), it returns an empty string.
If the condition is false (B5 is not empty), the CONCATENATE function is used to create the unique identifier.
"CTRI-" is a constant string used as a prefix for the identifier.
VLOOKUP(K5, Clients, 2, FALSE) performs a VLOOKUP function using the value in cell K5 as the search key. It searches for a matching value in the "Clients" range and retrieves the corresponding value from the second column.
TEXT(ISOWEEKNUM(J5), "00") extracts the ISO week number from the date in cell J5 using the ISOWEEKNUM function and formats it as a two-digit number.
TEXT(ROW($B$4) - ROW(B5), "000") calculates the row number difference between the current row and the fourth row in column B. It formats the difference as a three-digit number.
If any error occurs during the evaluation of the inner IF statement, the IFERROR function returns an empty string.
If the condition in the outer IF statement (V5 is not empty) is false, the entire formula returns an empty string.
Therefore, the formula in Z5 is dependent on the formula in X5, as it uses the same logic to generate the unique identifier based on the conditions and values in the corresponding rows.


What I want is that the formula in z, after looking to X and found no repetition to continue with the next numbering 002,003,004