Display specific value with VBA

[kayzip]

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

[protonLeah]

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)

[humdingaling]

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

Please Login or Register  to view this content.

[kayzip]

That was Exactly what I am looking for.
thanks humdingaling for the help