Need all values in column B listed that match a corresponding label in column a

Hi,

I need help with a function that will return a list of every value in column B that match a common value in column A. For Example If three cells is column A have the word "Colorado" in them I am hoping to have a formula that would list all of the value from column B that correspond to the word Colorado.

Any help is much appreciated!

Will a Pivot Table work for you?