Originally Posted by Pecoflyer

I don't see why the SUBSTITUTE in col D is necessary
does the job


@tispivey


Using entire columns as reference is bad practice
Use Excel Tables instead as dynamic reference

As for the IFERROR function, do not apply it before you have ascertained that your formula works correctly
In this case if you want to hide the NA error, OK, but suppose, for some reason, it returns a VALUE error? IFERROR will hide that also leading to incorrect results
IMO the ISNA function is safer