How to: Search a text value in a column then return the corresponding row text value

[Thetest123]

Hi, I'm wondering if someone can help me figure out the correct excel formula. Essentially I have two columns, one with text names and the other with text locations. I need a formula that will search the entire column for a specific location and then return the corresponding name that is associated with that column's cell. For example, if there are 30 names in column 1 and 30 different locations in column 2. If I search for England, I want the formula to return for me the corresponding name in column 1 that is attached to England in column 2. Any advice would be greatly appreciated!

[#2]

@Thetest123 , perhaps like

=IFNA(INDEX(<column2>,MATCH(<location name>,<column1>,0)),"no such")

[#3]

@Sergei Baklan 

Hi! Thank you so much for your response! I've attached a sample of what I was describing in the previous post. Can you please show me what the formula would be for if I want it to return the name associated with location England after searching column 2?

[#4]

@Thetest123 ,

That is like