Retrieving Multiple items from a table/sheet/array

rhube851 · Newbie Joined: 03 May 2012 Posts: 1 Location: London

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?

teracl275 · Newbie Joined: 13 May 2012 Posts: 2

Sorry its new to me also

JohnV · Posted: Mon May 14, 2012 8:38 am Post subject:

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.