Hi, I have two lists from different sources that I need to make sure that the contents of the lists are positioned in the same place within their cell.
In the above example, I need the contents “Green Cells” to be positioned in exactly the same position within their cell as the contents of the “Yellow Cells”.
I have attempted to add or subtract spaces but to no avail.
What I am attempting to do is use Matching formula
“=MATCH(E2&D2,$‘Mailman’‘s Route’.A$1:A$538&$‘Mailman’‘s Route’.B$1:B$538,0)” where the “Green Cells” are E and the “Yellow Cells” are $‘Mailman’s Route’ .A$1:A$538.
The other part of formula works, if I cut and paste from “E” into “A$” and I can get a Match to work without doing anything to the “D” and “B$” cells.
The Yellow List is taken from a database and arrives to me an Excel Sheet that I open in Libre Calc
As I have 16 Green List and up to 33 Yellow Lists per Green Lists I really need to automate.
I have done the cut and past thing as a workaround but I would like to automate the process as I do not have the time to do cutting and pasting.