=IF(B2="","",SWITCH(B2,"りんご","林檎","ぶどう","葡萄","バナナ","バナナ","未登録"))

=IF(B2="","",SWITCH(LEFT(B2,2),"りん","林檎","ぶど","葡萄","未登録"))
