Forum Discussion
IF THEN Formula
I need assistance creating a formula that will populate the GE BATCH# field from another worksheet if the TRACKING ID# is the same as shown. Then I would create conditional formatting for the cells that have been populated with a GE batch#.
Can you please assist?
| SMART/AS400 Batch # | GE Batch # | Tracking ID# | Deposit Date | BOA Accnt # | Accnt Name | (BAI) | Deposit amount | ERA WEB | Payer/ check # |
| T6707 | 27-Aug-2018 | 4426262004 | SHERIDAN EMERGENCY PHYSICAN SERVICE | 165 | 7,100.77 | FCSO INC. DES:HCCLAIMPMT ID:1346287166 INDN:SHERIDAN EMERGENCY PHY CO ID:6593514335 PPD PMT INFO:TRN*1*802670093*1593514335~ |
| Scanned Batch | Description | U Tracking ID | U assignment | GE Batch Total | Deposit Date | GE Batch# | AS400 Amt | GE AMT posted | AS400 Batch# | AS400 posted |
| 386979 | Kend Eft Uhc 483.69 | T6707 | $483.69 | 9/14/2018 | 53565 | $483.69 |
