Formula to Auto assigned Id_Number as Input in Sheet
What Formula should I used get desired JV number output
> Here In Sheet I what to get out similar as shown in JV Number column, Point to be note number id in JV number should be assign as per entry in sheet.
1) So Here in variation# column the entry is against variation num. VAR0012814 so number assign to it should be JV001, now whenever new entry is done with same variation number again at any position in sheet the JV number it should get JV001.
2) Next entry in Variation# column is VAR0012816 , VAR0012817 and so on. in reference of these entry JV number output should follow same pattern as shown in picture.
Answers

You may have to create a "helper" sheet with the variation numbers on it in one column, and the corresponding JV # next to it. Then do a vlookup to that sheet as your formula in the JV column.
Your "helper" sheet could just have these 2 columns:
Then your formula back on your main sheet could look like this. I converted it to a column formula so that any new rows added would automatically have the formula. Also, as a best practice, I typically lock my formula columns.
Hope this helps!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!