Google Sheets Search Column Instead of Row

How To
1

I would like to retrieve columns as variables from Google Sheets just like the Google Sheets Search Rows Make Module. I feel like it’s simple to do but for some reason I’m having a mental block.

Here is an example of what I am trying to achieve:

image

image
image1438×731 41.2 KB

From the above spreadsheet I would like to use the variable of the titles in column A to input the actual data from column B into the next scenario.

For instance creating a Google Docs document from a template where {{Title One}} would print 11111 on the newly generated document.

I can get it to work with the Google Sheets Search Rows Make Module and list everything from left to right in rows but I’d rather make a spreadsheet that scrolls down because it is easier to fill out on mobile vertically instead of horizontally.

This method works but not preferred:

image
image827×117 5.04 KB

Thanks!

2

use this: =column(A1) this will give you the column ID, for A1 will be 1

Additionally, you can utilize the combination of the INDEX and MATCH functions in Google Sheets to create a Cartesian axis-like reference system for selecting rows and columns.

With the INDEX function, you can retrieve the value located at the intersection of a specific row and column. The MATCH function, on the other hand, allows you to find the position of a certain value within a row or column.

Together, these functions can be used to dynamically retrieve data from specific rows and columns based on given criteria. This offers flexibility and the ability to create powerful lookup operations in your Google Sheets.

2 Likes