Searching data in two columns and returning data from a third column

My columns didn't paste like I wanted them to- Column A contains the city, columns B contains 3 numbers separated by dashes, column C contains 1,2, or 3. Sorry.

You might need a helper column that you can hide. try entering =A2&C2 in column D, which should give you "Boston1", then fill down the length of your data and hide the column (just to make it pretty)

then in your formula cell write =index(B:B,Match(city&#,D:D,0)) where "city" = the cell you are typing the city you want to look up and "#" = the cell containing the number you want from the city.

I havent yet discovered a good way to do a countifs for finding multiple criteria in differnet columns.

Thanks, qikslvr. Being a minimalist, I sometimes overlook adding helper columns.
I appreciate your help.

Dave