Spreadsheet: 869003d1715694361-vlookup-response-not-changing-based-on-logical-test-workbook-1
Sheet: Billing Master

Blank | 1a_SbrID | 2_PatLName | 2_PatFName | 2_PatMName | 2_PatSuffix | 3_PatBirthdate | 3_PatSex | 4_SbrLName | 4_SbrFName | 4_SbrMName | 4_SbrSuffix | 5_PatAddr | 5_PatCity | 5_PatState | 5_PatZip | 5_PatPhone | 6_PatRel | 7_SbrAddr | 7_SbrCity | 7_SbrState | 7_SbrZip | 7_SbrPhone | 8_Reserved | 9_OtherSbrLName | 9_OtherSbrFName | 9_OtherSbrMName | 9_OtherSbrSuffix | 9a_OtherSbrPolicyGroup | 9b_reserved | 9c_Reserved | 9d_OtherInsPlanProgram | 10a_EmpRelatedYes | 10b_AutoAccidYes | 10b_AutoAccidState | 10c_OtherAccidYes | 10d_claimcodes | 11_SbrPolicyGroup | 11a_SbrBirthdate | 11a_SbrSex | 11b_Qual | 11b_otherClaimID | 11c_InsGroupName | 12_PatSignature | 12_PatSignatureDate | 13_SbrSignature | 14_IllnessDate | 14_Qual | 15_OtherDate | 15_Qual | 16_UnableToWorkFrom | 16_UnableToWorkTo | 17_RefProvLName | 17_RefProvFName | 17_RefProvMName | 17_RefProvSuffix | 17_RefProvQual | 17a_RefOtherID | 17a_RefOtherIDQual | 17b_RefNPI | 18_AdmissionFrom | 18_AdmissionTo | 19_AdditionalClaimInfo | 20_OutsideLabCharge | 21_DiagCodeA | 21_DiagCodeB | 21_DiagCodeC | 21_DiagCodeD | 21_DiagCodeE | 21_DiagCodeF | 21_DiagCodeG | 21_DiagCodeH | 21_DiagCodeI | 21_DiagCodeJ | 21_DiagCodeK | 21_DiagCodeL | 21_IcdIndicator | 22_ResubCode | 22_OriginalRefNum | 23_PriorAuth | 25_BillTin | 25_BillTinType | 26_ClaimRef | 27_AcceptAssignmentYesNo | 31_RenLName | 31_RenFName | 31_RenMName | 31_RenSuffix | 31_RenProvSignatureDate | 32_FacilityName | 32a_FacilityNPI | 32b_FacilityProvNum | 32_FacilityAdd1 | 32_FacilityAdd2 | 32_FacilityCity | 32_FacilityState | 32_FacilityZip | 33_BillPhone | 33_BillName | 33_BillAdd1 | 33_BillAdd2 | 33_BillCity | 33_BillState | 33_BillZip | 33a_BillNPI | 33b_BillProvNum | 33b_BillProvNumQual | PayerName | PayerAdd1 | PayerAdd2 | PayerCity | PayerState | PayerZip | CLIANum | 24a_ServiceFrom_1 | 24a_ServiceTo_1 | 24b_POS_1 | 24c_Emg_1 | 24d_ProcCode_1 | 24d_Modifiers_1 | 24e_DiagPtrs_1 | 24f_Charge_1 | 24g_Units_1 | 24h_EPSDT_1 | 24h_FamilyPlan_1 | 24i_renprovnumqual_1 | 24j_renprovnum_1 | 24j_rennpi_1 | 24_Note_1 | 24a_ServiceFrom_2 | 24a_ServiceTo_2 | 24b_POS_2 | 24c_Emg_2 | 24d_ProcCode_2 | 24d_Modifiers_2 | 24e_DiagPtrs_2 | 24f_Charge_2 | 24g_Units_2 | 24h_EPSDT_2 | 24h_FamilyPlan_2 | 24i_renprovnumqual_2 | 24j_renprovnum_2 | 24j_rennpi_2 | 24_Note_2 | 24a_ServiceFrom_3 | 24a_ServiceTo_3 | 24b_POS_3 | 24c_Emg_3 | 24d_ProcCode_3 | 24d_Modifiers_3 | 24e_DiagPtrs_3 | 24f_Charge_3 | 24g_Units_3 | 24h_EPSDT_3 | 24h_FamilyPlan_3 | 24i_renprovnumqual_3 | 24j_renprovnum_3 | 24j_rennpi_3 | 24_Note_3 | 24a_ServiceFrom_4 | 24a_ServiceTo_4 | 24b_POS_4 | 24c_Emg_4 | 24d_ProcCode_4 | 24d_Modifiers_4 | 24e_DiagPtrs_4 | 24f_Charge_4 | 24g_Units_4 | 24h_EPSDT_4 | 24h_FamilyPlan_4 | 24i_renprovnumqual_4 | 24j_renprovnum_4 | 24j_rennpi_4 | 24_Note_4 | 24a_ServiceFrom_5 | 24a_ServiceTo_5 | 24b_POS_5 | 24c_Emg_5 | 24d_ProcCode_5 | 24d_Modifiers_5 | 24e_DiagPtrs_5 | 24f_Charge_5 | 24g_Units_5 | 24h_EPSDT_5 | 24h_FamilyPlan_5 | 24i_renprovnumqual_5 | 24j_renprovnum_5 | 24j_rennpi_5 | 24_Note_5 | 24a_ServiceFrom_6 | 24a_ServiceTo_6 | 24b_POS_6 | 24c_Emg_6 | 24d_ProcCode_6 | 24d_Modifiers_6 | 24e_DiagPtrs_6 | 24f_Charge_6 | 24g_Units_6 | 24h_EPSDT_6 | 24h_FamilyPlan_6 | 24i_renprovnumqual_6 | 24j_renprovnum_6 | 24j_rennpi_6 | 24_Note_6 | 24a_ServiceFrom_7 | 24a_ServiceTo_7 | 24b_POS_7 | 24c_Emg_7 | 24d_ProcCode_7 | 24d_Modifiers_7 | 24e_DiagPtrs_7 | 24f_Charge_7 | 24g_Units_7 | 24h_EPSDT_7 | 24h_FamilyPlan_7 | 24i_renprovnumqual_7 | 24j_renprovnum_7 | 24j_rennpi_7 | 24_Note_7 | 24a_ServiceFrom_8 | 24a_ServiceTo_8 | 24b_POS_8 | 24c_Emg_8 | 24d_ProcCode_8 | 24d_Modifiers_8 | 24e_DiagPtrs_8 | 24f_Charge_8 | 24g_Units_8 | 24h_EPSDT_8 | 24h_FamilyPlan_8 | 24i_renprovnumqual_8 | 24j_renprovnum_8 | 24j_rennpi_8 | 24_Note_8 | 24a_ServiceFrom_9 | 24a_ServiceTo_9 | 24b_POS_9 | 24c_Emg_9 | 24d_ProcCode_9 | 24d_Modifiers_9 | 24e_DiagPtrs_9 | 24f_Charge_9 | 24g_Units_9 | 24h_EPSDT_9 | 24h_FamilyPlan_9 | 24i_renprovnumqual_9 | 24j_renprovnum_9 | 24j_rennpi_9 | 24_Note_9 | 24a_ServiceFrom_10 | 24a_ServiceTo_10 | 24b_POS_10 | 24c_Emg_10 | 24d_ProcCode_10 | 24d_Modifiers_10 | 24e_DiagPtrs_10 | 24f_Charge_10 | 24g_Units_10 | 24h_EPSDT_10 | 24h_FamilyPlan_10 | 24i_renprovnumqual_10 | 24j_renprovnum_10 | 24j_rennpi_10 | 24_Note_10 | 24a_ServiceFrom_11 | 24a_ServiceTo_11 | 24b_POS_11 | 24c_Emg_11 | 24d_ProcCode_11 | 24d_Modifiers_11 | 24e_DiagPtrs_11 | 24f_Charge_11 | 24g_Units_11 | 24h_EPSDT_11 | 24h_FamilyPlan_11 | 24i_renprovnumqual_11 | 24j_renprovnum_11 | 24j_rennpi_11 | 24_Note_11 | 24a_ServiceFrom_12 | 24a_ServiceTo_12 | 24b_POS_12 | 24c_Emg_12 | 24d_ProcCode_12 | 24d_Modifiers_12 | 24e_DiagPtrs_12 | 24f_Charge_12 | 24g_Units_12 | 24h_EPSDT_12 | 24h_FamilyPlan_12 | 24i_renprovnumqual_12 | 24j_renprovnum_12 | 24j_rennpi_12 | 24_Note_12
 |  | A | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST | 97110