Hi, I have a lookupfile that contains a list of hosts, (one column named hosts), this list maybe subject to change. I want to complete a search that will compare this lookup file to hosts in any specific index and return a table showing ok or missing if there is no match. All searches I have attempted so far are happy to return either or, is the only option here to rename the field in the hostfile or any suggestions on how to complete this? host (from lookup file) host (from index) match host1 host1 ok host2   missing host3 host3 ok ... View more