I am working on building a Vacation tracker and I am trying to create a formula that depending on the name of employee and the vacation code counts the number of hours used and provides the remaining balance from the alloted balance. This is the function I am using but it is returning the #N/A error

=IF(AND(Vacations[[#All],[Employee Name]]=M31:M34,Vacations[[#All],[Vacation Code]]=2),N30-Vacations['# of days taken]*8,FALSE)

Can someone please help with this?