Spreadsheet: 785656d1656527050-needing-xlookup-to-cross-reference-multiple-criteria-book
Sheet: Raw

batch_number | payment_source |  | payer_short | pay_date | effective_date | check_number | check_amount |  | Transfer | Payment
RS3003 | 835 Mode - From File |  | Miami | 2022-06-02 00:00:00 | 2022-05-27 00:00:00 | RS-3003 | 2310 |  |  | 2310
XQ8098 | 835 Mode - From File |  | Miami | 2022-05-23 00:00:00 | 2022-05-20 00:00:00 | [NAME] | 2415 |  |  | 2415
GV2842 | 835 Mode - From File |  | Miami | 2022-05-20 00:00:00 | 2022-05-19 00:00:00 | GV-2842 | 305 |  |  | 305
US7482 | 835 Mode - From File |  | Miami | 2022-05-18 00:00:00 | 2022-05-13 00:00:00 | US-7482 | 439 |  |  | 439
WB1636 | 835 Mode - From File |  | Miami | 2022-05-18 00:00:00 | 2022-05-13 00:00:00 | WB-1636 | 2310 |  |  | 2310
WT7869 | 835 Mode - From File |  | Miami | 2022-05-17 00:00:00 | 2022-05-12 00:00:00 | WT-7869 | 105 |  |  | 105
RR2763 | 835 Mode - Manual |  | Miami | 2022-05-17 00:00:00 | 2022-05-11 00:00:00 | RR-2763 | 420 |  |  | 350
XN1746 | 835 Mode - From File |  | Miami | 2022-05-12 00:00:00 | 2022-05-07 00:00:00 | XN-1746 | 1890 |  |  | 1890
JY5913 | 835 Mode - From File |  | Miami | 2022-05-04 00:00:00 | 2022-04-30 00:00:00 | JY-5913 | 610 |  |  | 610
XQ1784 | 835 Mode - From File |  | Miami | 2022-05-02 00:00:00 | 2022-04-29 00:00:00 | XQ-1784 | 2100 |  |  | 2100
EE6115 | 835 Mode - From File |  | Miami | 2022-05-05 00:00:00 | 2022-05-09 00:00:00 | EE-6115 | 125.93 |  |  | 125.93
IG9979 | Claims Mode |  | Miami | 2022-06-08 00:00:00 | 2022-05-19 00:00:00 | IG9979 | 5250 |  |  | 5250
AN6972 | Claims Mode |  | Miami | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | AN-6972 | 210 |  |  | 210
JP2070 | 835 Mode - From File |  | Miami | 2022-05-25 00:00:00 | 2022-05-24 00:00:00 | [NAME] | 2310 |  |  | 2195
JP2070 | 835 Mode - From File |  | Miami | 2022-05-25 00:00:00 | 2022-05-24 00:00:00 | [NAME] | 2310 |  |  | 115
WR1348 | 835 Mode - From File |  | Miami | 2022-05-20 00:00:00 | 2022-05-19 00:00:00 | WR-1348 | 334 |  |  | 334
KG5716 | 835 Mode - From File |  | Miami | 2022-05-17 00:00:00 | 2022-05-17 00:00:00 | KG-5716 | 2110 |  |  | 1995
KG5716 | 835 Mode - From File |  | Miami | 2022-05-17 00:00:00 | 2022-05-17 00:00:00 | KG-5716 | 2110 |  |  | 115
LR7886 | 835 Mode - Manual |  | Miami | 2022-05-10 00:00:00 | 2022-05-10 00:00:00 | LR-7886 | 4335.4 |  |  | 4086.4
LR7886 | 835 Mode - From File |  | Miami | 2022-05-10 00:00:00 | 2022-05-10 00:00:00 | LR-7886 | 4335.4 |  |  | 879
OE1818 | 835 Mode - From File |  | Miami | 2022-05-03 00:00:00 | 2022-05-03 00:00:00 | OE-1818 | 2225 |  |  | 1995
OE1818 | 835 Mode - From File |  | Miami | 2022-05-03 00:00:00 | 2022-05-03 00:00:00 | OE-1818 | 2225 |  |  | 230
AT8722 | Claims Mode |  | Miami | 2022-05-31 00:00:00 | 2022-05-21 00:00:00 | AT-8722 | 1384.1 |  |  | -199.9
AT8722 | Claims Mode |  | Miami | 2022-05-31 00:00:00 | 2022-05-21 00:00:00 | AT-8722 | 1384.1 |  |  | 1151.1
RA2709 | Claims Mode |  | Miami | 2022-05-20 00:00:00 | 2022-05-14 00:00:00 | RA-2709 | 840 |  |  | 840
SQ4870 | Service Lines Mode |  | Miami | 2022-05-12 00:00:00 | 2022-05-10 00:00:00 | SQ-4870 | 840 |  |  | 840
UY1713 | Claims Mode |  | Miami | 2022-05-12 00:00:00 | 2022-05-07 00:00:00 | EFT-1794938 | 105 |  |  | 105
CE1527 | Claims Mode |  | Miami | 2022-05-18 00:00:00 | 2022-05-03 00:00:00 | CE-1527 | 210 |  |  | 210
RR3760 | Service Lines Mode |  | Miami | 2022-05-05 00:00:00 | 2022-04-30 00:00:00 | RR-3760 | 1050 |  |  | 1050
UD7709 | 835 Mode - From File |  | Miami | 2022-06-02 00:00:00 | 2022-05-30 00:00:00 | UD-7709 | 945 |  |  | 945
PY3083 | 835 Mode - From File |  | Fresno | 2022-05-03 00:00:00 | 2022-05-02 00:00:00 | [NAME] | 2929.5 |  |  | 2929.5
VB1499 | 835 Mode - From File |  | Fresno | 2022-05-03 00:00:00 | 2022-05-03 00:00:00 | VB-1499 | 12295 |  |  | 12180
VB1499 | 835 Mode - From File |  | Fresno | 2022-05-03 00:00:00 | 2022-05-03 00:00:00 | VB-1499 | 12295 |  |  | 115
EK1670 | Claims Mode |  | Fresno | 2022-05-05 00:00:00 | 2022-05-02 00:00:00 | EK-1670 | 2976.12 |  |  | 203.9
EK1670 | 835 Mode - From File |  | Fresno | 2022-05-05 00:00:00 | 2022-05-02 00:00:00 | EK-1670 | 2976.12 |  |  | 2570.36
EK1670 | Service Lines Mode |  | Fresno | 2022-05-05 00:00:00 | 2022-05-02 00:00:00 | EK-1670 | 2976.12 |  |  | 201.86
DP8632 | Service Lines Mode |  | Fresno | 2022-05-20 00:00:00 | 2022-05-19 00:00:00 | DP-8632 | 8850 |  |  | 8850
RH3233 | Claims Mode |  | Fresno | 2022-05-06 00:00:00 | 2022-05-02 00:00:00 | RH-3233 | 935 |  |  | 935
IG9979 | Claims Mode |  | Houston | 2022-06-08 00:00:00 | 2022-05-19 00:00:00 | IG9979 | 1500 |  |  | 3500
OP7836 | Service Lines Mode |  | Houston | 2022-04-19 00:00:00 | 2022-04-19 00:00:00 | OP-7836 | 583.2 |  |  | 583.2
OP7836 | Service Lines Mode |  | Houston | 2022-04-22 00:00:00 | 2022-04-19 00:00:00 | OP-7836 | 583.2 |  |  | 0
IG9979 | Claims Mode |  | Tampa | 2022-06-08 00:00:00 | 2022-05-19 00:00:00 | IG9979 | 10875 |  |  | 10575
ZX1995 | Service Lines Mode |  | San Diego | 2022-04-26 00:00:00 | 2022-04-26 00:00:00 | ZX-1995 | 134.1 |  |  | 134.1
IG9979 | Service Lines Mode |  | San Diego | 2022-06-07 00:00:00 | 2022-05-19 00:00:00 | IG-9979 | 17925 |  |  | 300
QG4849 | Service Lines Mode |  | San Diego | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | QG-4849 | 668 |  |  | 668