RedirectList() bug?

It appears that RedirectList() throws an error when the last hop is a 404 URL.

For example, this URL — https://www.penfed.org/learn/First-Time-Home-Buyer-Mistakes-Things-To-Avoid — is actually a chain that looks like this:

  1. '301' to http://www.penfed.org/learn/first-time-home-buyer-mistakes-things-to-avoid
    (lower-case version, but non-secure)
  2. '307' to https://www.penfed.org/learn/first-time-home-buyer-mistakes-things-to-avoid
    (secure version via HSTS policy)
  3. then '404' to https://www.penfed.org/learn/first-time-home-buyer-mistakes-things-to-avoid

(Yes, I know rules should be combined - that's why I'm working on this now.)

Rather than showing those URLs, RedirectList() gives a #VALUE! error. I've tested many URLs, and my results seem to point to this error being caused by a 404 in the last hop.

-Tim W.