Forum Discussion
Align duplicates from two columns to same rows in Excel + additional rows left & right
troyyy Ah, yeah! Forgot about those. Due to the limitations of VLOOKUP and since you don't have access to the newer functions, the easiest would be to place the first keyword column to the left of all others. Done that and added the correct VLOOKUP formulae. See attached file ending with "_rev.xlsx".
If, on the other hand you can not move the columns around, you can make VLOOKUP find a match towards towards the left of the "lookup column", using the technique describe in the attached link.
https://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose
Alternatively, use a combination of INDEX and MATCH. Both methods are demonstrated in the file ending with "......_rev2.xlsx".
troyyy Not sure I follow, but if you put a header on the "online Marketer" sheet that matches the headers for similar columns on the "Top 1000....." sheet, you could use the INDEX / MATCH solution provided earlier.
Hey Riny_van_Eekelen
yes, I tried to use the INDEX / MATCH formula you suggested before and tried to adjust it to this situation.
But I simply can't get it working.
The main issue is that yes, I can get Full Names to align with each other but how to also align the other columns after the Full Name?
Basically I'm able to say: Align Full Name "Howard Kogan" from Column A with Full Name "Howard Kogan" from Column C.
But I want to say: Align Full Name "Howard Kogan" from Column A with Full Name "Howard Kogan" from Column C AND the following Data from Column D, E, F and so on.
And this is what I don't understand and where my skill is not good enough to understand what I need to do to also align Data from the other Columns and that they follow Data from Column C basically.
Any thoughts?
troyyy Sorry don't follow. Column A doesn't contain a name.