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.
View attachment 26810
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.
View attachment 26810