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

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

there are many ways to achieve what you want
here is one way

if your sheet is set out like this

Row\Col	A	B	C	D	E	F	G
1	Apple	500		->	Watermelon
2	Orange	250		->	Manggo
3	Manggo	1000		->	Pineaple
4	Pineaple	600		->	Apple
5	Watermelon	700			orange

then something like this can be use

Sub LookUpValue()
    
    Dim cell As Range
    
    For Each cell In Range("E1:E5")
        
        cell.Offset(, 1) = Range("A:A").Find(cell.Value).Offset(, 1)
        
    Next
    
End Sub