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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post