A Google Spreadsheets function that uses a search_key to look in the first column of a specified range and return the value in a column of the range, specified by a 1-based index, from the first row in which the search_key is found. An optional fourth parameter may be set to FALSE to ensure only an exact match is returned. The vertical version of HLOOKUP. Do not use for Excel which has [vlookup].
Questions tagged [gs-vlookup]
501 questions
0
votes
1 answer
vLookup not working as expected
Now my formula for this may be wrong, but I am trying to collect data in google docs based on a sheet which contains responses from a google sheets survey.
The link to the google spreadsheet is here.
The first sheet of the document contains the…
wakey
- 2,283
- 4
- 31
- 58
0
votes
1 answer
Google Spreadsheet lookup and return another value
I'm using google spreadsheet and am trying to search for one value, then return a value in a corresponding cell. So for example, in sheet 2, I want to make a list of all of names in column A (sheet 1) that have a specific value (say 2 for instance)…
user3000523
- 1
- 1
- 1
0
votes
1 answer
Create array with vlookup
I want to conditionally grab lines from a database-style spreadsheet in Google Spreadsheets (a list with a name, location, description, price) after checking the value with a vlookup - I've used this a while ago and expected it to CONTINUE an array…
Louis Maddox
- 5,226
- 5
- 36
- 66
0
votes
1 answer
Script in Google Spreadsheets - VLOOKUP
I have a for loop that we're trying to run that identifies the last row on another sheet, and populates a VLOOKUP in the cell next to it. For some reason I keep getting a variable error. Here's the code:
for (var c = 5; c < lstRow; c++) {
var…
Jeff
- 15
- 1
- 1
- 5
0
votes
2 answers
How to Perform a Lookup/Filter Across Google Spreadsheets Using Google Apps Script
I would like to use Google Apps Script to populate a spreadsheet with filtered data from another spreadsheet.
The source document is a list of employees (column A, NAME), with their reported hours (column B, HOURS), the project they are working on…
user2844817
- 1
- 1
- 1
0
votes
1 answer
VLOOKUP on computed cell values
I cannot have VLOOKUP to properly work if it has to match computed values.
Please see this example:
In test sheet, row 1 tests data in computed sheet, where B2 cell is the result of =RIGHT(A1, 4).
Value 1234 is not found
Meanwhile, on row 2 of test,…
neurino
- 11,500
- 2
- 40
- 63
0
votes
1 answer
cleaner syntax for IF /VLOOKUP
It happens sometimes that I need to test the return value of a function and decide whether to keep or modify it. When you do this in a single cell, it can lead to two calls to that function - for example
=IF(VLOOKUP(value, table, colNum, FALSE)="Not…
user41592
- 37
- 7
0
votes
1 answer
Summing specific cells within a column based on the current month in a google spreadsheet
I'm trying to build a function that has the following logic within cell E13 on a Google spreadsheet.
If current month equals January, perform the following operation in the column G labeled January: G4-G5-G6;
If current month equals February,…
user2522627
- 1
- 1
0
votes
1 answer
Sum if data exists in range and matches on another sheet
I have data in Google Sheets organized like so:
Sheet1:
Label Type
foo B
bar A
baz _(empty cell)
qux B
totalX quantity
totalY quantity
Sheet2:
Type X Y
A 2 5
B 1 3
C 3 4
I…
DevinRB
- 107
- 2
- 8
0
votes
3 answers
VLOOKUP alternatives
I am trying to do a VLOOKUP but its just not going to cut the mustard. There is no way I can alphabetize the first column in my list.
What I am wondering is there any alternatives or combinations of functions that I could use along VLOOKUP in the…
lcm
- 1,737
- 6
- 17
- 40
0
votes
3 answers
-1
votes
1 answer
Why is nesting the "unique" function not working?
So I've put a few hours into this and I've finally hit a sticking point that I can't figure out. I'm using a players "Code" to pull information from 1 sheet to another. Normally this would be easy but before I pull the information, I'm running it…
LADD
- 95
- 8
-1
votes
1 answer
Google Sheets Query needed to select values matching in other column
been trying to solve this query for a while, tried many variations and never was successfull..
I have the following data set..
I am trying to write a =QUERY() to get the output like in the image below..
Mr.Eboy
- 45
- 9
-1
votes
2 answers
Google Sheets - Lookup - Return last matching value problem
I am attaching a link to the google sheet that I am working on.
I am trying to create a list on the "sales" sheet that would pull the "next payment due" based on the last matching result from the "payments" sheet. The cell that is used as reference…
-1
votes
1 answer
I'm trying to write a simple script in google sheets, that reads an ID number from a list and outputs the name associated to it
I'm trying to write a simple script in google sheets, that reads an ID number from a list and outputs the name associated to it. Essentially like an attendance list.
I'm sure its a very simple script but I've been stuck on it for a while.
I've…
user7067152
- 11
- 1