Questions tagged [google-sheets-vlookup]
17 questions
5
votes
3 answers
Copy an entire Spreadsheet, Just Preserve the Values
I want to copy an entire spreadsheet of some 20+ sheets to a different location in Drive; however, I only want to preserve the hard values and formatting in each cell, and not the formulas (basically just taking a snapshot of the values). I have…
Warren Meroney
- 195
- 2
- 10
4
votes
4 answers
Why does my Google Sheets formula not automatically recalculate?
I have this formula in a cell in a 'Summary' sheet which is waiting for a new sheet to be created with its name being a date:
=IFERROR(VLOOKUP($A3, INDIRECT("'"&TEXT(BN$2,"m/d/yyyy")&"'!$E$6:$o$100"), 11, false), "")
However, when I add the new…
Brian T Hannan
- 3,925
- 18
- 56
- 96
3
votes
4 answers
Is there an arrayformula to fill all blank cells in a column with the content from the cell above?
In the following Google sheet:
A B
------------------------
1| Tom | something |
2| | something |
3| John | something |
4| Lana | something |
5| | something |
6| | something |
7| Jason |…
Rick Moore
- 31
- 3
3
votes
2 answers
Lookup multiple values in a single cell (comma separated) and then return the values to a single cell (also comma separated)
Using Google Sheets, I have the following two tables:
1st table
Size | Code
--------------
Large | L
Small | S
XLarge | XL
2nd table
Values | Codes
-------------------
Large,Small | L,S
XLarge,Small | XL,S
XLarge,large | XL,L
I need a…
user2304237
- 33
- 1
- 4
1
vote
2 answers
How could we use a formula in query Google sheet
I am unable to figure out how could we use formula within query results. I did not find any solution yet.
Like:
=query(sheet1!A1:Z,"Select A,B,Vlookup(D,sheet1!A1:A,1,false)");
Zamir
- 217
- 2
- 11
1
vote
2 answers
Search sheet for multiple matches in a single row
I would like to modify the following QUERY, or some formula variation that accomplishes the same result, to only be entered a single time at the top of the column and fill the cells below using ARRAYFORMULA
=IFERROR(QUERY(Items!$A$2:$T,"SELECT…
TC76
- 860
- 1
- 8
- 17
1
vote
1 answer
Sheets API v4 is returning #N/A for specific formulas
Sheets API v4 is returning #N/A when using vlookup formula. This specific error is happening with vlookup formula, but I have seen this very same issue on spreadsheets contains a big number of formulas. Seems like the API does not wait for the…
Rafael De Alemar Vidal
- 163
- 1
- 12
1
vote
1 answer
Looping through a set of values in google sheets
I have 2 sets of data. One is tank names
Tank Name
A1
A2
B1
B2
and the next is ON/OFF Data
ON/OFF
0
0
1
1
0
1
0
1
1
0
1
0
1
Now the result I am looking is, when the ON/OFF is 1 then the first tank is to be…
Shijilal
- 2,175
- 10
- 32
- 55
0
votes
1 answer
Pulling URL with =VLOOKUP from the table
Trying to get url from this link https://www.atanet.org/onlinedirectories/tsd_view.php?id=3856
I use the following formula: =VLOOKUP("Website",ImportXML(A1, "(//table[@id='tableTSDContent']//tr)"),2,0)
But unfortunately, it does not pull out the…
Hanna
- 137
- 10
0
votes
1 answer
Get COUNT (Array Formula) from another Sheet
Need help on how to get the count from Worked to Productivity sheet:
https://docs.google.com/spreadsheets/d/1c3HdMq4PA50pYr88JqPoG51jvru8ipp8ebe4z5DczTQ/edit#gid=1891370548
In Productivity Sheet (A2), get unique names that worked within the time of…
KB John
- 89
- 5
0
votes
2 answers
How to search in multiple columns in google sheets?
I have several columns as follows:
Nugegoda Branch Nugegoda Branch REF Malabe Branch Malabe Branch REF
102 2222 103 33333
201 2222 203 …
Umesha Gunasinghe
- 779
- 3
- 13
- 29
0
votes
1 answer
Google Apps Script setFormula function
I'm facing some issues with Googles Apps Script while using the following code to insert ArrayFormulas in 5 specific cells:
function AddForm() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
const sh=ss.getSheetByName('sheetname');
var…
user13332855
- 37
- 6
0
votes
1 answer
Google Sheets Search from Database and insert into specific cell on edit
i need some help from someone who is more experience than me.
I've the following formula
=WENNFEHLER(SVERWEIS($B$3;$B6:C;{2};0))
and the following script
function copyIntoCell() {
var spreadsheet = SpreadsheetApp.getActive();
…
mKeey
- 133
- 1
- 13
0
votes
2 answers
Output only items from Column B to Column C when All 3 conditions are met in Column A
I have two columns, one with account types (-A -B -C -D -E, etc) I only want Column B to be output into Column C if the account holder from Column B has all three account types (-A -B and -C)
Objective: Output Row from Column B into Column C IF…
Dragon Kyn
- 94
- 1
- 8
0
votes
2 answers
Modifying apps script array items with formulas
I am trying to create/modify elements of an array based on CONCATENATE and VLOOKUP formulas. When the code is executed, the formula is displayed instead of the results.
The goal is to take information in a section of the Specification Matrix sheet,…
Chris MMgr
- 49
- 2
- 8