Anthony Pinnegar
Member
In the below table I would like Column K to automatically say Not Applicable if one of the 8 departments mentioned in cells N11 to N18 is entered in Column C, which is imported from a different spreadsheet.
For example, rows 6,7 and 8 are all in departments that require a new starters audit, but row 9 is not. They work in IT, for example.
For example, rows 6,7 and 8 are all in departments that require a new starters audit, but row 9 is not. They work in IT, for example.
Code:
Column G Column H Column I Column K
Starters Audit Assigned To Audit due Audit complete
Row 6 JSW3 15/02/2015 Yes Complete
Row 7 JSW3 03/03/2015 Yes Complete
Row 8 JSW3 27/02/2015 Yes Complete
Row 9 JSW3
Last edited by a moderator: