Ah, vlookup… So handy. Let’s you get a value from one column by searching for a specific “key” in another column. But you know there’s one thing about vlookup that has always annoyed the hell out of me. (It’s probably annoyed you, too.)
Google Sheets Formula to Create a Right Outer Join
Step by step instructions for recreating the equivalent of a (SQL) right outer join in Google Sheets.