Hi everyone,
how do I manage to merge the data in screenshot 1 and 2 (two different tabs) into something that looks like screenshot 3?
Screen1.PNG
Screen2.PNG
screen3.PNG
Many thanks in advance!
Hi everyone,
how do I manage to merge the data in screenshot 1 and 2 (two different tabs) into something that looks like screenshot 3?
Screen1.PNG
Screen2.PNG
screen3.PNG
Many thanks in advance!
You could use vlookup or index/match or Power Query.
Thank you for your reply, kersplash. I tried with vlookup, but wasn't successful with it - my formula must have contained an error.
As kersplash said, Index/Match is my preferred way
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks