Hello everyone, It would be great if someone could help me. In the attached table, in the first tab "Overview," there is employee data with their classification (columns B & C). The other tabs contain pay scale tables, each valid for specific periods. By entering the period in columns F and G, the correct value for the pay group and step should be read from the pay scale tables and entered in column H. So, my draft is producing incorrect values. I'm curious. Thanks
Manfred


.

Attached Files

PK VKO_Abrechnungsabgleich.xlsx (23.1 KB, 6 views)