list alternate cell based off search function results

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.

Hi

I think we will need to see an example file that includes your lookup function. I'm assuming that you are returning multiple results from your searches, not just the first result. So it would be good to see exactly what you have set up, and what you want returned.

rylo