Comparing two columns

[Closed]
Report
-
Hello,

I want to know the formula for the below

If column A is having list of cities eg Chennai and column b is having list with extension eg chennai_bus.xls. I want to match the cities of the two columns and get the output as chennai_bus.xls