Hi.
I have a function which looks at the value in column A (band names) and then returns and output to column C (genre) based on a search of another sheet (Genre_categories) in the workbook.
The problem I'm having is that the search function is looking for individual words rather than the whole band name. So 'Pink Floyd' in Cell A2 results in a search for 'Pink' and 'Floyd' and returns 'Pop' and 'Rock' as a genre (eg: pop,rock).
So how can I modify the search to make sure it looks only for the 'whole' band name?
This if my formula:
Thanks.
Bookmarks