Q: Using Vlookup and avoiding the repeating value while fetching data from another sheet I am using Vlookup to fetch a list of cities for a given country present in another sheet but in the same workbook. The problem I facing is if I am looking for all the cities from India and Delhi is present is the 7th row so the Vlookup will give me the first 7 cells as Delhi (I removed the $ in the range input so that the starting row always changes) similarly ahead I will get recurring cells from the lookup range when the country is not India. How can I avoid that without using the Query function?  
Running the whole process and then using distinct to get the list is too inefficient for my project and the process slows down tremendously.
