Dear Forum,
I have three columns in Excel. Column A contains the names of various academic institutions. Almost all of these occur more than once. Column B contains the city or cities they belong to. Column C contains a list of cities, some of which are the actual cities the institution belongs to, some of which are not. I am looking for a formula for Column D which tells me if the value in Column C matches a value in Column B for a given academic institution.
Thank you for any guidance,
Stephen
I have three columns in Excel. Column A contains the names of various academic institutions. Almost all of these occur more than once. Column B contains the city or cities they belong to. Column C contains a list of cities, some of which are the actual cities the institution belongs to, some of which are not. I am looking for a formula for Column D which tells me if the value in Column C matches a value in Column B for a given academic institution.
Thank you for any guidance,
Stephen