ExcelBanter - compare two columns and find the matched id

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - compare two columns and find the matched id (https://www.excelbanter.com/new-users-excel/446840-compare-two-columns-find-matched-id.html)

SIRI

compare two columns and find the matched id

i have a two columns in excel with columns names and email ids now i have to search email id comparing with the name columns and display it in another column

Spencer101

Quote:

Originally Posted by SIRI (Post 1604598)

i have a two columns in excel with columns names and email ids now i have to search email id comparing with the name columns and display it in another column

I'm not sure I understand what you mean...
Search in what for what and display what where?

Perhaps an example workbook would help.

All times are GMT +1. The time now is 07:56 PM.