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