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).

Continue reading

© 2020 Alie. All Rights Reserved
Author's picture

Alie

Evolutionary biologist. Movement ecologist. R enthusiast. (More about me here.)

PhD student

Switzerland/Canada