View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DA DA is offline
external usenet poster
 
Posts: 104
Default VLOOKUP TABLE ERROR

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