SO I have 2 columns of account #'s Column C has 98,000, a list of all accounts ever created. Column A has only 60,000 accounts consisting of ONLY the accounts that have been active in the last 5 years.
I want to Match the values in Column A to the Values in Column C and Do one of 2 things.
1) Preferably, have Column A Sort to Mach Column C and move that number to the adjacent cell in column A. if there is no Match then just leave the cell in that ROW blank.
or
2)Sort and match placing the value in Column B if there is a match somewhere between the two columns if no Match then the cell in that row would just be blank
Column A Column B Column C
663695 453942
514549 449234
169486 495180
Please and Thank You
Bookmarks