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

Retrieving Multiple items from a table/sheet/array

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
rhube851
Newbie
Newbie


Joined: 03 May 2012
Posts: 1
Location: London

PostPosted: Thu May 03, 2012 5:18 am    Post subject: Retrieving Multiple items from a table/sheet/array Reply with quote

I have a spreadsheet of payments made to clients. Each row has the client code, the payment date, and the amount as well as other items. I have a separate sheet formatted as a remittance (invoice like ) document. I want to be able to add two parameters on to the 2nd sheet, Client code and payment date, and have calc pull through the pertinent data for all rows from the first sheet.

I do something similar elsewhere using LookUp. But that is pulling one data item through where each item on the first sheet is unique. This is pulling multiple items through where each item is unique on two data values not 1.

Any ideas anyone?

Many thanks

Also does anyone else regularly get hangs/crashes when trying some copy and paste actions?
Back to top
View user's profile Send private message
teracl275
Newbie
Newbie


Joined: 13 May 2012
Posts: 2

PostPosted: Mon May 14, 2012 5:45 am    Post subject: Reply with quote

Sorry its new to me also
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Mon May 14, 2012 8:38 am    Post subject: Reply with quote

The 1st client code is in Sheet1 cell A2. In Sheet 2 enter
=Sheet1.A2
then pull* this formula down the column to pick up other rows.

* Click out of the cell then back into it. Click and hold on the box at the lower right corner and pull down.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion 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