Complicated Look-Up
 

Good Day. I'm struggling with a lookup. The data is as follows:

01/04/10 230
01/04/10 $71,302.73
01/05/10 226
01/05/10 $70,909.90
01/06/10 225
01/06/10 $70,793.88
01/07/10 220
01/07/10 $69,269.93
01/08/10 218
01/08/10 $68,450.56
01/09/10 77
01/09/10 $9,027.15

The first row is the number of accounts and the second row is the amount the
accounts are worth.

What I am trying to accomplish, on a separate worksheet, is to do a lookup
and return the following:

1/4/10 | # of Accounts | $ of Accounts
1/5/10 | # of 1/4 Accts - 1/5 Accounts | $ of 1/4 Accts - 1/5 Accounts

So, in other words, Joe gets a certain number of accounts to work on Monday.
On tuesday, the number of accounts worked on Monday was Monday - Tuesday,
etc.

Since there are 2 1/4/10 rows, I'm having trouble saying get the first row,
then grab the 2nd row for the Amount.

TIA, any help would be very appreciated,

Greg

Complicated Look-Up
 

For the dollar amounts:
=LOOKUP(A2,'Sheet1'!A$1:B$10)

For the qty:
=INDEX('Sheet1'!B$1:B$10,MATCH(A2,'Sheet1'!A$1:A$1 0,0))

LOOKUP will find the last instance of a value (if its sorted) while MATCH
will find the first instance.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Greg" wrote:

Good Day. I'm struggling with a lookup. The data is as follows:

01/04/10 230
01/04/10 $71,302.73
01/05/10 226
01/05/10 $70,909.90
01/06/10 225
01/06/10 $70,793.88
01/07/10 220
01/07/10 $69,269.93
01/08/10 218
01/08/10 $68,450.56
01/09/10 77
01/09/10 $9,027.15

The first row is the number of accounts and the second row is the amount the
accounts are worth.

What I am trying to accomplish, on a separate worksheet, is to do a lookup
and return the following:

1/4/10 | # of Accounts | $ of Accounts
1/5/10 | # of 1/4 Accts - 1/5 Accounts | $ of 1/4 Accts - 1/5 Accounts

So, in other words, Joe gets a certain number of accounts to work on Monday.
On tuesday, the number of accounts worked on Monday was Monday - Tuesday,
etc.

Since there are 2 1/4/10 rows, I'm having trouble saying get the first row,
then grab the 2nd row for the Amount.

TIA, any help would be very appreciated,

Greg