I need help writing a formula that will list the values of B3:B53 for which
A3:A53 is equal to a specifiic value.
A3:A53 are set up with dropdown menus to select from a list of values (in
this case locations) and I need to have a cell which lists the values in B
for each item in the list.
Is there a way to do this without creating a mile long if statement?