In the formula =VLOOKUP(A1,D1:H30,3,FALSE), the lookup value (A1) is being looked for in _.
=VLOOKUP(A1,D1:H30,3,FALSE)
column D
column F
columns D through H
column H