My original request for help was solved by user NBVC with the formula =IF(D2="Billable",IF(OR(ISNUMBER(MATCH(E2,Billing_Departments,0)),ISNUMBER(MATCH(B2,Associates,0))),"Y","N"),"N"). I can’t thank this person enough for their help.
So I woke up at 3:00 AM thinking about this and thought of another scenario that could appear. I've attached another Excel file.
The equation is the same as the original with one change, If D2 is billable and E2 is in the named range return a "Y" otherwise return "N". But also, if E2 isn't found in the named range, look for a match between the project and name and the same information on the billing exclusions worksheet and return a "Y" if found, otherwise return "N".
I tried changing and adding a vlookup to end but didn't work.
Bottom line is I'm trying to determine what hours should be billable based on either the billing department or an exception which would be a project and name combination.
Bookmarks