Hi..
My query is as follows:
I want to compare the values of two columns. But it is not that simple. Data in 1st column is not in proper order so I have to use text to columns twice to extract data. Extracted data will be in two separate columns say A and B. I have to compare data from column A with data in Column C (master list). If match is found, copy data or cell value from column A to Column D. If match is not found, go to Column B and copy corresponding value from Column B to Column D. For this comparison, I want to use index and match function.
Kindly help me in this regard.
Thank you for time spent in going through this thread.
Bookmarks