View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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."