Vlookups and filtered tables

I have a spreadsheet of every municpality in a state, along with data on each municipality. I want to do a vlookup from another spreadsheet to find things like the GNIS code and population using the name of a village. The snag is that there are towns and villages that share the same name. Is there a way to add compound references to vlookup? vlookup((C2 and '[otherworkbook.xls]Sheet'1!$H:$H='Village') ,'[otherworkbook.xls]Sheet'1!$G:$AH,15)?

Or do I have to go to my source spreadsheet and create new sheets by filtering for village/town/city/county, then copy/pasting those filtered tables into their own sheets?