My zip file is an example of what I want to do. In "total report" I have a list in alphabetical order. What I want is to input names in "wanted list" in any order, and have column C (highlighted) return the names from "total report". So far I get an answer indicating the correct position of my query, but I need it to reflect the name. TIA