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 If you are a MS365 subscriber, you could use FILTER as demonstrated towards the far right, in the attached file.
If FILTER is not supported in your Excel version you can revert to VLOOKUP. Come back here if you need more help.
Hey Riny_van_Eekelen
unfortunately I'm not a MS365 user. I've been looking into VLOOKUP trying to understand it. But I don't understand that formula or at least it doesn't work
I tried to do it - see the excel file.
But for whatever reason it doesn't work.
Any thoughts on that?
Cheers
Torge
troyyy Not sure, but have a look at the attached. With VLOOKUP, the lookup value should be in the first column of the lookup range. Done that in column G. The #NA errors indicate that the value in D is not found in C. Does this help?
Hello Riny_van_Eekelen,
okay. Now I have the keywords names. But I also want to have the correct "Search Volume" (from Column B) and correct "Keyword Difficulty Score" (from Column A) into Column H & I.
How to do that?
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".