Gate Pass Number Generate Automatically....

[JAMIR]

Hello,

I want to generate gate pass no. automatically. Gate pass no limit for 1 IV No. is 15 times. Like 1501 IV No. will continue as 15 Times as shown below. I have to start Gate Pass No.181010 to IV No.1501 by formula up to 15 times IV No.1501 found him. If 1502 found he should be generate next Gate Pass 181011 to IV No.1502. It is possible with formula?

Regards,


Zameer Shaikh

 

[ismailzkhan]

Hi Jamir,

As per my understanding you can use simple vlookup to get your desired result.

Regards,
I Khan

 

[oldchippy]

Hi Jamir,

The vlookup that ismailzhan suggests does the job, but is the "15 times" a maximum you can have? If it is then you will need some data validation on the "Inv No" to restrict entries to a maximum of 15.

 

[nazmul_muneer]

Dear Jamir,
According to your quoted problem, type the formula in I3
=IF(B3=1501,181010,181010+B3-1501) and copy down
Remember that, you have to validate data using condition that same IV no can not be repeat more than 15 times in the column B

 

[JAMIR]

Hi ismailzkhan / oldchippy & nazmul_meneer

Thank a lots for helping me... Cheers!!!

Regards,

Zameer Shaikh

 

[nazmul_muneer]

Happy to help you