View Single Post
 
Old 05-24-2025, 05:43 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In H2:
=IF(CONCATENATE(G2&TEXT(F2,"00"))<CONCATENATE('TVö D Bund Jul 23 - Feb 24'!$K$1&TEXT('TVöD Bund Jul 23 - Feb 24'!$J$1,"00")),OFFSET('TVöD Bund Jul 23 - Feb 24'!$A$1,MATCH(B2,'TVöD Bund Jul 23 - Feb 24'!$A:$A,0)-1,MATCH(C2,'TVöD Bund Jul 23 - Feb 24'!$2:$2,0)-1),OFFSET('TVöD Bund ab März 24'!$A$1,MATCH(B2,'TVöD Bund ab März 24'!$A:$A,0)-1,MATCH(C2,'TVöD Bund ab März 24'!$2:$2,0)-1))*D2

Copy down to your other cells.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote