I want to create a sum that returns a score if a certain word appears, ie if cell says High Street then score is 40 but there could be multiple answers. I have attached some test data that should explain.
if anybody could help it would be appreciated
Bookmarks