OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

vlookup not recognising names

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
plato
Newbie
Newbie


Joined: 08 Dec 2011
Posts: 1

PostPosted: Thu Dec 08, 2011 3:54 pm    Post subject: vlookup not recognising names Reply with quote

hello, Hoping someone may assist me please.I have started using Vlookup but my results do not end up as expected.Some are recognised,others are incorrect and some are not found.I have enclosed a picture here:
http://i1097.photobucket.com/albums/g350/gilnic/vllokuppic.png

THis shows the formula used and results.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Dec 08, 2011 4:30 pm    Post subject: Reply with quote

VLOOKUP does not work like this. Any resource on spreadsheets can explain in detail how it works. In this forum alone you find hundred topics at least.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group