Reply to thread

Message

[QUOTE="klmiura, post: 3673644"]
No this still does not work.  Let me give you more information:

worksheet 1

Payor Code:  Name		                	10/26/2006	9/26/2006(Hidden)
9/25/2006
0-30
31-60
AD HOC AETNA - EL PASO 			$0.00		                                        $0.00
Trying to lookup matching data from worksheet 2(below) that has the above
name (ad hoc aetna - el paso) from worksheet 1 to  Column A in worksheet 2
and then anything that matches that name, I need it to pull all claim amounts
from the column B (worksheet 2) that are <=10/26/2006 and >=09/26/2006 and
put them in the appropriate bucket (worksheet 1) ie above ..0-30, 31-60
etc...this is the amount that is still due within the date ranges for this
one payer as a total sum since their are over 5,000 records and the dates,
amounts and payers vary.

Worksheet 2

Payor Code : Name                                date of service
claim amount
AD HOC AETNA - EL PASO                           10/20/2006
$20
BLUE CROSS                                               07/18/2006
$30
MEDICAID                                                    06/01/2006
$10
AD HOC AETNA - EL PASO                             1/20/2006
$50
[/QUOTE]

Verification