If the basic LOOKUP function left you feeling a little underwhelmed, I'm sure you'll appreciate the VLOOKUP. It’ll help you sort out those table sorting issues – pun intended!
Also, this is the only tutorial you need to check if you want to know everything about how to use VLOOKUP in google sheets.
Being able to conditionally look for data is one of the pillars of well-done spreadsheets.
If you've ever wondered about the Google Sheets LOOKUP formula in all its variants, wonder no more. After reading this article, you’ll have no doubts on setting up your lookup table and how to use this powerful function.