Comparing columns, not identical

Column A- list of accounts

Column B- list of managers

Column C- a smaller list of accounts that should be in A

 

I need to compare columns A and C, then take the appropriate managers from list B and put them in a new column.  Problem is A and C are pretty similar, but not exact.  Is there a MATCH formula for comparing them, then building that new column with the appropriate data?  Thank you!

By: Brian Tarus

Leave a Reply

Your email address will not be published. Required fields are marked *