Thank you
I changed the look up column to 2, and still get the same errir.

"EricG" wrote:

Your lookup column index is 4, but your data range only has two columns (C
and D). Maybe your lookup range should be C712:F1154 or your lookup column
index should be 2? A value of 2 would correspond to column D, since it is
the second column in the data range.

HTH,

Eric


"da" wrote:

Hello
I keep getting an error when using Vlookup table formula. What I am doing
wrong?
Thanks
=vlookup(c709,C712:d1154,4)
c709 is the name to look up (Name of the employee)
C712:D1154 is the range
4 is the number of Column where the value to be found is (it is an employee #)
Lookup table is in the same worksheet.

thanks