The VLOOKUP function is a super popular formula but suffers from a major drawback. You can’t lookup data to the left!
However, there’s a sneaky trick that lets us VLOOKUP to the left, so we can search for a term and return a result from a column to the left of the original search column:
Continue reading How To VLOOKUP To The Left In Google Sheets?