By far the most common data wranging question that I get asked by friends and colleagues is “Without having to use R, how do I pull values from one table into another, based on matching shared values in another column?”
The answer is the almighty INDEX MATCH function in Excel. Actually, although I call it “the INDEX MATCH function,” it’s a MATCH function nested inside an INDEX function (basically, the MATCH function tells the INDEX function which value to pull).
