I need to do the following:
(1) Lookup the values in Worksheet #1, Column G,
(2) FIND the SAME value in Worksheet #2, Column E
(3) RETURN the Value from Worksheet #2, Column B (on the same row where the
lookup value was found in Worksheet #2, Column E


Worksheet #1, Column G
Apples

Worksheet #2
Col B Column E
ABC Apples

I want to see the value of "ABC", which corresponds to my value that was
within Column E.

Any help would surely be appreciated! Thanks all and Happy New Year!
Cheryl