help...

I've tried index, match, vlookup, sumproduct etc and cant work out how to check the following bank transactions...

'SANTANDERCARDS LTD **transaction 1
0207 28AUG19 , RINGGO , RICHMOND GB
'HALIFAX
'nuffield health
'0207 25AUG19 , RINGOPARKBYPHONE , SOUTH WEST TR GB
'TV LICENCE MBP
'EE LIMITED
'LBRUT DIRECT DEBIT
'BARCLAYS UK MTGES
'BARCLAYS UK MTGES

...against the below list of references and return column B value (e.g. credit card bill, gym, parking) if there is a match.

col A col B
SANTANDER Credit Card bill
nuffield Gym
RINGGO Parking

i.e. check transaction 1 against the list and return "credit card bill", then perform the same for the rest of the transactions

Thanks