A lookup with a difference
If the person does not exist and it doesn't come up in your defined
range, you will get the result of #N/A. You can use the iserror
function and use an if statement to have the result toggle to "Person
not in current list."
|