lookup to return text in multiple rows if one word found in a row against a scenario

[Makroz]

Hi i am trying to do a lookup by text and return a yes or no answer

I have made an example

so below im trying to find out locations where clive has been crazy

so if clive has been crazy at any point in the house i want it to return the word yes or crazy in the crazy? column against every instance in the scenario column where it states house

so the return in the crazy? column for the first 3 rows and the garage row should say crazy the rest should say sane!



Clive type Scenario Crazy?
Crazy clive house
Standard clive house
Clive bored house
Clive bored Car
Crazy clive Garage
Standard clive Car


Thank you

[XLent]

So, one option:

Please Login or Register  to view this content.

however, if you have a very large dataset you may find the above a little slow -- if performance is a concern you should sort your data by B, at which point you could use:

Please Login or Register  to view this content.

which, used in large volume, would perform better.