pull one value based on an adjacent cell value

[lumberjim]

hey,

I need to fill a cell with the tax rate based on which county is selected from a data list.

example attached.

if county = A2, then i want B2's contents.

I want it to do it automatically. So if I have a data list and the user selects county "a" in field D2, they get 1% in the field I need to use in my calculation(E2)
sample lj1.xlsx
'elp!

[etaf]

use
=VLOOKUP(D2,A1:B12,2,FALSE)

[AndyLitch]

Formula in E2 is =IF(D2<>"",VLOOKUP(D2,$A$2:$B$12,2,FALSE),"")

[lumberjim]

awesome! you guys rock!