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.

1 comment:

UA-44643247-1