I originally posted this on the end of the formula help, but believe it actually needed to be placed in a new thread.

What I'm trying to do is to develop a spreadsheet that will return all the values that equal 2 specific criteria. More specifically, we do a lot of state to state travel and I want to have a spreadsheet that will allow me to enter two states and will return all the customers that fit that data. I have the data sample on one tab and would like the formula on another. I've tried to create a vlookup formula, however it provides only one answer and multiple vlookups gives me multiples of the same answer. I've also tried a pivot table, but only able to get the count of the customers, not their names.

Does anyone have any thoughts?

Any help would be greatly appreciated.

Thanks