TGags wrote...
In colum a are a list of state codes, in column b are the corresponding sales
tax rates for that state.

If NY is in column c1, then I want d1 to equal the sales tax rate

D1:
=VLOOKUP(C1,$A$1:$B$51,2,0)

(51 rows if you're including D.C.)