Hello 
Please could someone help me write a formula, that looks up between workbook1 and named ranges/tables on workbook2.
In book1 I have a "Role" column (D) and then a "Name" column (E).
In book2 I have named ranges (also made into tables) that are headed with a variety of roles. One of which is "Leavers".
In book 1, I want to highlight the row in a colour, if the name in column E appears in the "Leavers" array in book2.
I have tried a variety of things, i.e. Match, VLookUp, but I think I must be mistyping somewhere...
Thanks in advance,
Kate

Please could someone help me write a formula, that looks up between workbook1 and named ranges/tables on workbook2.
In book1 I have a "Role" column (D) and then a "Name" column (E).
In book2 I have named ranges (also made into tables) that are headed with a variety of roles. One of which is "Leavers".
In book 1, I want to highlight the row in a colour, if the name in column E appears in the "Leavers" array in book2.
I have tried a variety of things, i.e. Match, VLookUp, but I think I must be mistyping somewhere...
Thanks in advance,
Kate