I have a rather complicated VLookup that is able to search several columns based off a dropdown menu, the only problem is that only the results for that column pop up so I do not have a reference for what row it was pulled from. I would like to be able to pulled up the contents of a cell in G when I my results are from column H or I.
For example:

G H I
a apples sweet, yummy
b bananas texture, yellow, yummy
c oranges orange, sweet, sour
d kiwis texture, green, sweet
e grapefruits sour, sweet, yucky, pink
f grapes green, red, yummy, sweet
g berries yummy, red, blue, seeds

If I search for Sweet in Column I, I also need A, C, D, E and F to populate in the following format:
G I
a sweet, yummy
c orange, sweet, sour
d texture, green, sweet
e sour, sweet, yucky, pink
f green, red, yummy, sweet

Currently I only get the contents of Column I.