Google Sheets VLOOKUP

November152018.png

Google Sheets VLOOKUP

Search • Sort • Share

This issue takes a look at using VLOOKUP in Google Sheets. I use this function in Google Sheets often. Few teachers have heard of it or its purpose. I use this function often when developing flexible solutions and searches. I use a real-world example in the lesson.

This issue takes a look at using VLOOKUP in Google Sheets. I use this function in Google Sheets often. Few teachers have heard of it or its purpose. I use this function often when developing flexible solutions and searches. I use a real-world example in the lesson.

I was requested by the Fine Arts department in my district to come up with a solution to their inventory access. They are working on a long-term solution but that is a few years away. They needed a way for teachers to search the list of available print titles in their music library. They had done the hard job of creating the list of items. This list was created on an Excel spreadsheet. I took the spreadsheet made it available online and used VLOOKUP to help them search through the lengthy list of titles.

The example in the issue is part of a larger solution I worked on. Sadly, they eventually decided to go in a different direction. All that hard work is still paying off though. I am able to take my experience and share the process with you. I will be referring to VLOOKUP in future issues.