Formula help

Tried to structure your formulae a bit, but without the sample failed to understand what could be wrong

=IFERROR(
LET(
   IsD,      TRIM('Key Log'!$A$4:$A$309) = TRIM($D$6),
   IsK,      TRIM('Key Log'!$C$4:$C$309) = TRIM($K$15),
   Include,  IsD * IsK,
   KeyTypes, FILTER('Key Log'!$F$4:$F$309, Include ),
   KeyNums,  FILTER('Key Log'!$K$4:$K$309, Include ),
   keyNum,   INDEX(KeyNums, ROW(A1) ),
   IF( INDEX(KeyTypes, ROW(A1)) = "Hard Key",
       "V" & keyNum, keyNum
   )
),
"")

=IF(A8="","",
LET(
    FilteredRows, FILTER( SEQUENCE(ROWS('Key Log'!$A$4:$A$309)),
                          ('Key Log'!$A$4:$A$309=$D$6) *
                          ('Key Log'!$C$4:$C$309=$K$15)
                  ),
    RowNum,       INDEX( FilteredRows, ROW(A1) ),
    Room,         INDEX('Key Log'!$C$4:$C$309, RowNum),
    Status,       INDEX('Key Log'!$E$4:$E$309, RowNum),
    Type,         INDEX('Key Log'!$F$4:$F$309, RowNum),
    DateVal,      INDEX('Key Log'!$D$4:$D$309, RowNum),
    IsAB,         OR( RIGHT(Room)= {"A","B"} ),
    DoorDesc,     IF(IsAB, "Combined Main & Room Door", "Main Door"),
    KeyDesc,      IF(Type="Swipe Key", "Swipe Key", "Hard Key"),
    DoorDesc & " "
)
)