Hello all,
I'm struggling a bit on this one... Here is my conundrum:
I have data in column A that matches C. I need the order of column A to remain untouched. Column C matches data of column D.
I need the data from column D to match A (which is the same a C but in a different order).
How can I get the data in column D to match column A with out finding each one and pasting the result one by one? I want to past the data in D in column B to match A (but from the C+D match).
This is confusing, I know...
I'm struggling a bit on this one... Here is my conundrum:
I have data in column A that matches C. I need the order of column A to remain untouched. Column C matches data of column D.
I need the data from column D to match A (which is the same a C but in a different order).
How can I get the data in column D to match column A with out finding each one and pasting the result one by one? I want to past the data in D in column B to match A (but from the C+D match).
This is confusing, I know...