This question is a continuation of a previous resolved questions - This code is perfect for what I am doing but.. I have a new issue
See image: in Column AN you have pharmacy and Temporary Lodging, then Column AT you see codes 97530 for both. I want to only put the below comment in for the one that shows "Pharmacy". How would I add this part to the existing code below? The call out would be " Unable to resolve. Incomatible POS/CPT combination". This example shows just one pharmacy call out but in reality that can be a list of them in this column. Also just like the below code already does, it scans a range AT:AX because the combination could appear in any one of these columns.
270 By definition this is a HCPCS for non-covered services. Need instruction on benefit response. Authorization has this code.",IF(SUM(COUNTIF($AV8
alysis required. Claims with Dental codes.",IF(COUNTIF($BB8:$B
nd Center issue 773 - CR1851",IF(COUNTIF($BB8:$B
e to resolve. Facility claim Rev code w/o CPT/HCPCS",IF(SUM(COUNTIF(
mand Center Issue #462 - Pharmacy claims CCA to resolve.","Analysis Required")))))