Ok. I think I got the above sorted out, but I'm still having a similar issue.
See FTC OBQ-PA attached.

On the "tools in PA" worksheet, columns F, G and H are returning #NA. I don't get it.
(Some won't appear because I had to cut the size of the source list to attach to this site, but most are still there.)