What's the best way to merge 2 tables keeping 1 column aligned?
Example: I have these 2 tables from which I want to make table 3:
TABLE1 color name1 red apple orange orange yellow banana green kiwi purple blueberry
TABLE2 name2 price apple $1 avocado $2 banana $.5 blueberry $.1
TABLE3 A B C D E color name1 name2 price red apple apple $1 orange orange yellow banana banana $1 green kiwi purple blueberry blueberry $.1 avocado $2
I want name1 to align with name2 across. What's the best way to do this?
I've been doing it by adding a column between name1 and name2 (column C above) and =if(b2=d2,1,0) copy/paste down column C, and scanning by eye for 0. Not only is that tedious, but each time I insert a blank D&E cell, I need to recalculate C by hand. There's got to be a better/simpler way. I'm OK with VBA but having trouble with vlookup for some reason
Thank you in advance.