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