Hi folks,

Noob at excel so would appreciate any help. I've attached an example.

Worksheet 2: Column A lists the basket types
Worksheet 2: Column D lists Fruit example.xlsxa type of fruit that should be in the basket

Worksheet 1 should provide a count the number of times a particular fruit has been mapped to a basket in worksheet 2. I've filled out basket 1 in the example.

Hope that makes sense and would appreciate any help.
Thanks,
Joe