If you are wondering if it is possible to create sequence numbers from clustered values, then you should definitely consider reading ahead to find out more. If a value is already present in the column of data that you are dealing with then you will simply have to obtain the sequence number, if not, you will need to form a new sequence number. You will need to utilize the VLOOKUP formula to conduct this task. For example, assume that the cluster values are located in B4 of Column B and then you will need to write the following formula:
= IFERROR ( VLOOKUP (B4,$B$3:C3,2, FALSE ), SUM ( MAX ($C$3:C3),1))
It is time for you to understand what the formula is all about.