Auto populate subitemcode

[ExcelNewbie2020]

i have a table in sheet 1 that has an item code with its corresponding sub item code and other table that has no corresponding sub item code "No sub item code"..
in sheet 2 column F is the input data. i need that, everytime i input an item code it will auto populate sub item code in column G but if there is no subitemcode it will return blank cells (see yellow color).


Many thanks,

Book1
	A	B	C	D	E	F	G
1	Sheet 1				Sheet 2	Input	Expected Result
2	Item code	Sub Item Code				Item code	Sub Item Code
3	AAA	AAA1				BBB	BBB1
4	AAA	AAA2					BBB2
5	AAA	AAA3					BBB3
6	AAA	AAA4					BBB4
7	AAA	AAA5					BBB5
8	BBB	BBB1				No Sub item Code 1
9	BBB	BBB2				CCC	CCC1
10	BBB	BBB3					CCC2
11	BBB	BBB4					CCC3
12	BBB	BBB5				AAA	AAA1
13	CCC	CCC1					AAA2
14	CCC	CCC2					AAA3
15	CCC	CCC3					AAA4
16	DDD	DDD1					AAA5
17	DDD	DDD2				No Sub item Code 2
18	DDD	DDD3				BBB	BBB1
19	DDD	DDD4					BBB2
20							BBB3
21							BBB4
22							BBB5
23						CCC	CCC1
24							CCC2
25							CCC3
26
Sheet1