Excel 2007 : how to match 2 columns and return value from the 3rd column

I am trying to apply the tax rate to different zipcodes. Attached excel file sheet AKzipcode shows Alaska zipcodes with city and State info. Sheet AKTaxRate shows tax rate for each city in Alaska.
I am looking for formula to find the corresponding tax rate to be inputted on sheet AKZipcode column D from the rate info on sheet AKTaxRate column A by matching both cities and states on both sheets. I need the state match cause use AK as an example but have a lot more states to do.
Could you please help. Thank you!

You can use SUMIFS() but first you'll have to clean up your data.
First - your tax rates are currently text values. Change them to numeric by typing a 1 in any empty cell. Select all your tax rate values then Paste Special - Multiply.
They should all be numeric now. Delete the 1 that you copied.
Second - some of your stae values have leading spaces. Get rid of those spaces.

Now you can use in D2 and dragged down:
=SUMIFS(AKTaxRate!A:A,AKTaxRate!B:B,B2,AKTaxRate!C:C,C2)

Thank you very much, Cutter. It works like a charm.

You're welcome. Don't forget to mark your thread as SOLVED (for instructions - click Forum Rules @ top of page and see rule #9).