Hi,
I need a formula to match 'employee name' (column A) to a given range (L2:M8) and if there's a match, to override 'the hours' to zero in column I.
For all other employees I want the total hours to remain the same.
I've attached a sample data.
Can you please help me with the formula on Column I?
Many thanks in advance.
Bookmarks