hello experts,

Mapping:

107507-0000 314071
921570-0000 324000

check Values and replace first 11 digits (this is on a different spreadsheet):
921570-0000-50-C
921570-0000-10-c
107507-0000-30-C
107507-0000-40-C


I would like to replace values based on the mapping. for example: if the mapping is 107507-0000 to 314071 then i would like to replace 107507-0000-40-C and 107507-0000-30-C to 314071-40-C and 314071-30-C respectively.

Thanks