=IFERROR(VLOOKUP(LOOKUP(2^15,SEARCH(Area!$A$1:$A$200,J3),Area!$A$1:$A$200),Area!$A:$B,2,FALSE),"AREA NOT ON LIST")

=IFERROR(VLOOKUP(LOOKUP(2^15,SEARCH(Area!A1:INDIRECT("A" & $X$3,TRUE),I5),Area!A1:INDIRECT("A"&X3,TRUE)),Area!$A:$B,2,FALSE),"AREA NOT ON LIST")

Original Formula= USA Dynamic Range Formula +Area Not On lIst