Comparing two columns

Closed

Nirmal - Aug 8, 2015 at 08:43 AM

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

Comparing two columns
Display two columns in data validation list but return only one - Guide
Excel compare two columns for partial matches - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download - Excel Forum
Macro to compare two excel sheets ✓ - Excel Forum
How to compare two Excel sheets with varying data ✓ - Excel Forum

Similar discussions

Comparing columns and returning value

Extract identical cells of 2 columns (excel)

Comparing Two Excel Sheets and copying like data to third sheet

Macro to compare 2 sheets and copy differences

Compare columns in two sheets and copy info across

Similar discussions

Subscribe To Our Newsletter!