All Questions
13 questions
0
votes
1
answer
101
views
Google sheet formula to search table for newest scan and alternate the return value
I am building a member database for the non-profit youth center I volunteer with. I did something similar using Google sheets and Forms for a former company in managing their inventory across ...
0
votes
1
answer
32
views
How To Assign Same IDs to Aliases/partial identicals Strings in the same Column in Google Sheets?
In short, I need a script or a formula able to scan the range D2:D21 / D2:D for strings "partial" matches and output corresponding IDS to Basic Strings Cells and their partial match cells in ...
- 779
1
vote
1
answer
179
views
How to do VLOOKUP in google app script with a concat value from 2 columns as the parameter
I just want to make a vlookup in google app script with the result of concat from 2 columns as parameter to match with a column from different spreadsheet and then take the values of the matched row. ...
- 68
0
votes
1
answer
66
views
Moving Row to another sheet and clear content/ ArrayFormula
Short story:
How do I modify the script below to clear contents in multiple cells in the row? For example Rows 7,13,24,25,34
Long story (in case there is a better solution):
I have been using this ...
- 21
0
votes
1
answer
893
views
Google App Scripts & Google Sheets - Equivalent of VLOOKUP/IMPORTRANGE - Using multiple spreadsheets
Objective:
I would like to eliminate the use of formulas (array formulas, importranges, and vlookups). Instead, I would like to use Google App Script to populate columns in the Child Database ...
- 419
1
vote
1
answer
39
views
How to use gSheets vlookup for joining a few columns?
I saw this post about using vlookup for joining two or more tables in google sheets.
However, I see it help joining just one column (see $C$4:$C$12). How would it work for a multiple columns?
VLOOKUP(...
- 36.7k
2
votes
1
answer
3k
views
Vlookup Exact Match Google Sheets
hoping for some help understanding why VLOOKUP is not returning exact text matches and is instead showing partial matches. Below is an example of my data.
As you can see in the screenshots, item R2FLG ...
-2
votes
1
answer
235
views
Data Validation (dropdown) and Vlookup for google script
I have a list of products and their ids in a sheet.
On the main sheet, I have a column of which accepts id as input. I need to create a dropdown for this column such that product name is displayed in ...
- 107
0
votes
1
answer
96
views
Google Sheets Email - Vlookup showing REF value in PDF
Hoping you could help me with this, I have created a system that automatically sends the current sheet as an attachment in an email with body and subject text.
I have one problem that I cant seem to ...
0
votes
1
answer
153
views
Is it possible to write a script for this Vlookup error?
I have three interrelated google sheet spreadsheets. In the worksheet "Input data" names and different roles are defined.
In the table sheet "Assignment" these specific names are assigned with values:...
- 79
0
votes
1
answer
334
views
Google Sheets - Two-way lookup pulling data from multiple sheet tabs
I've been working on a sheet where I want to have and input tab and output tab.
The input tab is basically a table and the output tab will be a calendar (of sorts).
In my example:
Sheet1 = input tab
...
- 63
0
votes
0
answers
105
views
Vlookup in Googleappscripting
I have this code developed but I may be doing something wrong with my vlookup formula. I am trying to create a report that allows me to lookup a primary key in my source spreadsheet. Once it finds the ...
1
vote
1
answer
346
views
Find answer for data in A in predefined list of answers - VLOOKUP - Google Spreadsheets
I've got a google spreadsheet with a main sheet tab. column A contains a bunch of company names, some of which repeat, and are included multiple times. In column B i want to have a predefined unique ...
- 10.2k