Find and return a word, in a list of words, that is in a single cell.

Hey there.

I have found similar posts regarding this, but I am struggling with the ending. I have a Cell which contains a full location (Rondebosh Western Cape South Africa). I then have a list of regions (Western Cape)(Northern Cape) etc. I want to look for the regions in the full location and then not return a true or false, but the actual region itself (Western Cape). I hope someone can help me. Thanks so much!!

With your full location in cell A1, and the regions in cells H1:H2 you could use this formula:

=IFERROR(INDEX(H1:H2,MATCH(TRUE,INDEX(ISNUMBER(FIND(H1:H2,A1)),0),0)),"No match")

The range H1:H2 can be expanded to however many regions you have.

Thanks soooo much Andrew!!!! Big help my man!