Something like this?...I'm assuming, however, that once you input your Media Format from the dropdown, that it will not be changed (because only the first part of the ID will change). Paste into cell G3 on Sheet1 and it should auto update:

=IFERROR(INDEX(Lists!$B$7:$B$10,MATCH(Sheet1!A3,Lists!$A$7:$A$10,0))&" -"&TEXT(ROWS($G$1:G3)-ROW($G$2),"000000"),"")
Hope this helps.