Need Formula based on selection from a List.

[TSing3]

In column E I can select 4 words from a list: Quick, Standard, Major, and Advanced. If I select Quick in column E, I want the adjacent cell in column F to automatically populate 2018QK1. If I select Standard in the next cell in column E, I want the adjacent cell to populate 2018SK1. Selecting Major would populate 2018MK1 and Advanced would populate 2018AK1.

How do I fix the sheet so he next time I select Quick the adjacent cell would populate 2018QK2 since I already have a 2018QK1? Same thing for Standard, Major, and Advanced as well.

 

[wideboydixon]

Book1
	E	F
2	Quick	2018QK1
3	Standard	2018SK1
4	Major	2018MK1
5	Advanced	2018AK1
6	Quick	2018QK2
7	Standard	2018SK2
8	Standard	2018SK3
Sheet1

Cell Formulas
Range	Formula
F2	=IF($E2="","","2018"&LEFT($E2,1)&"K"&COUNTIF($E$1:$E1,$E2)+1)

WBD

 

[TSing3]

Works! Awesome! Thank you!

 

[TSing3]

Ok, how would I make it to where only the number changes?

For example:

Quick - 2018QK1
Standard - 2018SK2
Major - 2018MK3
Advanced - 2018AK4
Quick - 2018QK5
Standard - 2018SK6
Major - 2018MK7
Advanced - 2018AK8

 

[wideboydixon]

Book1
	E	F
2	Quick	2018QK1
3	Standard	2018SK2
4	Major	2018MK3
5	Advanced	2018AK4
6	Quick	2018QK5
7	Standard	2018SK6
8	Standard	2018SK7
Sheet1

Cell Formulas
Range	Formula
F2	=IF($E2="","","2018"&LEFT($E2,1)&"K"&COUNTA($E$2:$E2))

WBD

 

[TSing3]

Works again! Thanks for the help!