Scoring System Sum

Stand Alone Forecourt Parade  High Street
are the only entries with scores

Is your sample all the possible entries you may have

Parade will it always be "parade of shops" if so it may be easier to include that in the table and just use a simple lookup

in the table parade has a space at the end "parade "
is this a typo addition or will that be the case in other entries

if you can change K2 to "parade of shops"
then this simple lookup would work

=INDEX($I$1:$L$1,MATCH(B2,$I$2:$L$2,0))

But I suspect there are a lot more entries and combinations needed

strange i cannot add a spreadsheet ......
i will post this and then try again with an EDIT

EDIT
managed to get it to work after restarting chrome

To deal with partial matches, like In Big Shops Parade of Stores, City Center Parade of Shops and so on you may use:

Formula:

Please Login or Register  to view this content.

But Parade in K2 cannot end with non breaking space (character 160). So it cannot be
"Parade "
but
"Parade" <- I'd opt for this way

or
"Parade "
but with a standard space at the end

This thread has been larked as solved - is it???

If so, then please take a moment to say 'thank you' to your volunteer helper.