ExcelBanter - Index match formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Index match formula (https://www.excelbanter.com/excel-worksheet-functions/454238-index-match-formula.html)

Index match formula

hi gurus!

im stuck trying to figure out a formula.

i have a list of name with unit number in column C eg ; a1-2-3 ABC condominium
and in column z a list of condominium names which i want to match and output would be the best match of column C and column Z

All times are GMT +1. The time now is 01:09 AM.