Master the VLOOKUP Function
You can do a lot of fancy stuff with the humble VLOOKUP formula in Google Sheets.
Learn 4 advanced ways we use VLOOKUP here at CIFL:
1) On an entire column with ARRAYFORMULA
2) From a separate Sheet with IMPORTRANGE
3) Looking up multiple criteria
4) Reverse VLOOKUP (from right-to-left)
Master the VLOOKUP function here (cheat sheet included):
https://codingisforlosers.com/learn-v...