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

function problem [Solved]

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


Joined: 20 Nov 2007
Posts: 2

PostPosted: Tue Nov 20, 2007 3:01 am    Post subject: function problem [Solved] Reply with quote

I have a sheet containing these

NAME DDI EXT
Circle Writeup 23339595 9595
Bird Advert Times 23331515 1515
Listenor Advert Times 23333535 3535
Man Advert Times 23332525 2525
Bird Advert Circle 23334545 4545
Listenor Advert Circle 23335555 5555
Man Advert Circle 23336565 6565
23337575 7575
23338585 8585

I also have another sheet with these:

19/11/0715:53 27446875 3535 NO ANSWER 21

I would like to add a field which computes (in this case 3535) and pastes "Listenor Advert Times" in the field. Basically I want to get the third column, cross-reference it with the first sheet and return the Name accordingly.

How could I do that?


Last edited by neoakira on Tue Nov 20, 2007 5:03 am; edited 1 time in total
Back to top
View user's profile Send private message
davidh182
OOo Advocate
OOo Advocate


Joined: 01 Apr 2004
Posts: 413

PostPosted: Tue Nov 20, 2007 4:23 am    Post subject: Reply with quote

VLOOKUP won't work because the lookup column is not the first column in the lookup array.

You can use MATCH to locate the row and then OFFSET to get the Name.
Back to top
View user's profile Send private message Send e-mail
neoakira
Newbie
Newbie


Joined: 20 Nov 2007
Posts: 2

PostPosted: Tue Nov 20, 2007 5:02 am    Post subject: Reply with quote

I am able to use vlookup as the first sheet is just a reference. I managed to do what I wanted


Thanks davidh182
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