Can I expand on this formula to include more then one match value?

can I match to customer number between date1 and date2.
so out of my invoice list I can call up all the invoices for one
certain customer from feb. 15 to march 21.

Thanks again for all the help.

Wally

On Tue, 14 Feb 2006 10:15:26 -0500, WTG
wrote:

Bob This worked great except for the second formula keeps giving me
the same value as the first. Can you see my error.

And I took your advice about pointing to the customer id.

=MATCH(C3,Invoices!C$7:C$5000,0)
=MATCH("rmb",Sheet1!B$1:B$500,0)


=MATCH(1,INDEX((Invoices!C$7:C$5000=Sheet1!$C$3)* (ROW(Invoices!C$7:C$5000)A6),0),0)
=MATCH(1,INDEX((Sheet1!B$1:B$500="rmb")*(ROW(She et1!B$1:B$500)A1),0),0)


Thanks again for the help.

Wally

On Fri, 10 Feb 2006 17:38:35 -0500, "Bob Tarburton"
wrote:

in Sheet2!A1
=MATCH("rmb",Sheet1!B$1:B$500,0)
in Sheet2!A2
=MATCH(1,INDEX((Sheet1!B$1:B$500="rmb")*(ROW(She et1!B$1:B$500)A1),0),0)
Copy A2 down as far as you need to

in Sheet2!B1
=IF(ISNA($A1),"",INDEX(Sheet1!A$1:A$500,$A1))
copy down and across as far as you need to go

tips
1. of course you can type "rmb" in a seperate cell and point to it.
2. If you adjust the "$1" in column A, make same adjustment to the formulae
in the rest of the columns.