Please help with this example

[Amuserad]

Hi,

I would like to seek your help. In the attached example, I have two sheets - sheet 1 and sheet 2.

Sheet 2 - contains the types and variety of fruits and vegetables available in my shop
Sheet 1 - is a selection where I can select the type (either fruit or vegetable) and the list is expected to list all the fruits or vegetables available

I tried to use VLOOKUP formula to fetch the values but it is only fetching the last value and displaying in the list. I would like to list all the items.

Can please help me with this to provide me a simple formula to list all the items. Thank you very much.

 

[Peter_SSs]

Duplicate to Please urgently help with this sample

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.