Display specific value with VBA

Hi
I hope someone can solve my simple issue from this following simple data :

A	B	C	D	E	F	G
Apple	500		->	Watermelon	700
Orange	250		->	Manggo	1000
Manggo	1000		->	Pineaple	600
Pineaple	600		->	Apple	500
Watermelon	700

all I want to do is, in column F displays the results as in column B base in column E using VBA

sorry if the question as has already been made in this forum, and sorry for my bad english

Thank you in advance