Tutorial on how to add a vlookup to a Google Form. When you need to add a vlookup to a Google Form you must nest the vlookup formula within an array so that the formula will populate as users fill in the form. Google Forms adds rows rather than filling in existing rows in the spreadsheet which is why it is necessary to nest the vlookup within an array formula.
Showing posts with label vlookup. Show all posts
Showing posts with label vlookup. Show all posts
Monday, October 21, 2013
How to add a vlookup to your Google Form
Tutorial on how to add a vlookup to a Google Form. When you need to add a vlookup to a Google Form you must nest the vlookup formula within an array so that the formula will populate as users fill in the form. Google Forms adds rows rather than filling in existing rows in the spreadsheet which is why it is necessary to nest the vlookup within an array formula.
Subscribe to:
Posts (Atom)