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:
- '301' to http://www.penfed.org/learn/first-time-home-buyer-mistakes-things-to-avoid
(lower-case version, but non-secure) - '307' to https://www.penfed.org/learn/first-time-home-buyer-mistakes-things-to-avoid
(secure version via HSTS policy) - 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.