If search finds a certain word in range then add specific comment to different cell
Posted on 2016-08-31
How do I modify this so that it searches a range not single cells? So for example instead of AV2, I would like the range of AV:AZ to be searched for the word "A9270". Same for Fluoride. Is it also possible to use Floride, Oral, Dental, Tooth. Any one of these could appear in a range. Then what would happen is the comments in the "" if match word is found will be added in a different column.
=IF(ISNUMBER(SEARCH("A9270",$AV2)),"A9270 By definition this is a HCPCS for non-covered services. Need instruction on benefit response. Authorization has this code.", IF(ISNUMBER(SEARCH("Fluoride",$AV2))," Analysis required. Claims with Dental codes.","Analysis Required"))