Works for me. Depending on your system's regional settings, you may need to change the comma separators to semi-colons, which you can do via a simple Find/Replace. See attached.

Do note that your rows with just '9' in column B won't find a match, because your TVöD Bund sheets have '9a', '9b', 9c', so there's nothing for the '9' to match with.

Attached Files

PK VKO_Abrechnungsabgleich.xlsx (22.0 KB, 1 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]