VLOOKUP TABLE ERROR


D

da

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
 
Ad

Advertisements

E

EricG

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
 
F

Fred Smith

Then it means the value you are looking up (C709) does not exist in your
table.

Regards,
Fred
 
Ad

Advertisements

D

da

I am sorry, but the value in C709 does exist. I know for sure it is there>
anyway, I found out the correct formula.
My only prob is I want to type just the Last name and First Initial, instead
of full last and first name, which is in my lookup table. Can it be done with
just last name and first initial?
thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returning #N/A result 2
VLOOKUP & IF used with > or < 7
Excel Vlookup Help 0
Lookup on worksheet 1
VLookUP formula help! 5
VLookup 1
VLOOKUP just returns formula 1
Sum Vlookup where there are blanks 1

Top