Excel, search data in different Sheet2 and put it back on Sheet1 based on their column

[11392]

This is Sheet1
zIqku.png

This is Sheet2
HO4of.png

I would like to search the Fruit in Sheet2, identify their group, and put it back in Sheet1, under column B (Group)

Desired output
psMj5.png

What is the best way to do this?

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[11392]

Thanks. PFA the sample data.

[JeteMc]

Try pasting the following into cell B3 on Sheet1 and then dragging the fill handle down to cell B6:

Please Login or Register  to view this content.

Let us know if you have any questions.