Excel Table lookup Named Range

I am working with an Excel file that someone else created (attached). The Formula in column F (Table4) does a vlookup to the named range Goal and brings back values from Column R, based on a match between values in E and P. In some cases it is updating the values in column F correctly and other cases it doesn't, for instance the value in F3. In column F, It is an array formula, so I understand you need to do CTRL + SHIFT +ENTER to add { }. I am not that familiar with working with array formulas, and named ranges, so not sure if that might an issue as well. I can't figure out why Column F isn't always updating correctly. Unfortunately, I cannot change the formula or how the spreadsheet is setup, as used for other functions. Thanks for any info to assist.

AliGW, thanks for the fast reply. Good catch on the error in Column D with the Space in G oal. That was actually a typo on my part, I updated that column D for privacy reasons (it has another word besides goal, but they do match on the original sheet between the Table 1 and Named Range Goal), but it still doesn't work after fixing Column D. Attached is an updated copy.
As for the CTE, I just mentioned because i noticed the { }. I am just fishing for ideas because this one has me stumped.

Thanks for sending the updated formula. It definately works. Unfortunately, as I mentioned I need to try and figure why the original is not working as it is used for other functions. Thanks.

thanks again. I appreciate the help.