Posted to microsoft.public.excel.misc
|
|
VLOOKUP TABLE ERROR
Thank you but it did not fix the problem. I still get #N/A error
"Dave Peterson" wrote:
If you want an exact match, then you'll want that 4th parameter to be False (or
0).
And if you want to bring back the 4th column in that lookup range, make sure you
have 4 columns:
=vlookup(c709,c712:f1154,4,false)
Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble
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
--
Dave Peterson
.
|