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

V-Lookup in Openoffice Calc 3.0.1

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


Joined: 05 Aug 2008
Posts: 66

PostPosted: Wed Apr 15, 2009 5:49 am    Post subject: V-Lookup in Openoffice Calc 3.0.1 Reply with quote

How to do the V-Lookup from file to file in OpenOffice calc v 3.0.1

Sheet to Sheet means it is possible.
Back to top
View user's profile Send private message
vivek
Newbie
Newbie


Joined: 01 Apr 2009
Posts: 4
Location: Bangalore

PostPosted: Sat Apr 18, 2009 1:48 am    Post subject: Reply with quote

Have u woked wit vlook up in microsoft, Its just the same.
Back to top
View user's profile Send private message Yahoo Messenger
vivek
Newbie
Newbie


Joined: 01 Apr 2009
Posts: 4
Location: Bangalore

PostPosted: Sat Apr 18, 2009 1:52 am    Post subject: Reply with quote

Press F1 u ill get a help window, there u search for vlookup u ill get entire details about vlookup.
Back to top
View user's profile Send private message Yahoo Messenger
naresh_nagaraj
Power User
Power User


Joined: 05 Aug 2008
Posts: 66

PostPosted: Mon Apr 20, 2009 5:39 am    Post subject: V-Lookup in Openoffice Calc 3.0.1 Reply with quote

Suppose when we are having the File naresh.xls and kumar.xls in Openoffice ,HOw we can able to do the V-Lookup.

When we are doing like this as similar to MS-Office it is not working properly.


Please kindly give the solution
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Apr 20, 2009 6:12 am    Post subject: Reply with quote

You did not mention external links. You asked about VLOOKUP without providing a formula.
Nobody will ever be able to help you.
- Operating system? Which version? OOo runs on many platforms.
- Files on network? Which network?
- What do you do exactly? Simply paste a formula.
- What exactly do you get?
- What exactly do you expect to get?

I can assure you that it does work in at least 3 different ways.
[Tutorial] External Links In Calc
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
naresh_nagaraj
Power User
Power User


Joined: 05 Aug 2008
Posts: 66

PostPosted: Mon Apr 20, 2009 8:46 pm    Post subject: V-Lookup in Openoffice Calc 3.0.1 Reply with quote

Operating System : Windows
Version : XP Professional


Openoffice Version is 3.0.1


When we are working in Sheet1 to Sheet2 the V-Lookup is working fine.

But When we are doing from File to File it is not working

That too If When I am in Naresh.Xls in Openoffice and then if we go to next file "kumar.xls" ,when selecting the Data it doesnt allow for dragging


So please kindly provide the solution
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