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
2
votes
2 answers
What formula or method could I go to subtract amounts from values in a range using a table
I have a master sheet with values of what I would sell for. I want to create a formula or rules where I can subtract commission based on the value of the cell. I want to be able to edit from the table only so I don't have to mess around with…
Akkasca
- 47
- 6
2
votes
1 answer
How do I use VLOOKUP to fill out an hourly calendar schedule?
Rather than typing out the function I am dealing with since it is rather long and arbitrary without the columns it is referencing, I have provided a simplified mock-up of my spreadsheet here. Be sure to make a copy of it and not edit the original…
MBearnstein37
- 75
- 8
2
votes
1 answer
Google Sheet match category with multiple keywords to strings
How do I match a category list(column D) with 3 columns of keywords (columns A B C) to a list of strings(column H) and have the result of column I?
I was thinking vlookup and tried something like this, but looks like it doesn't work:…
sojim2
- 1,245
- 2
- 15
- 38
2
votes
1 answer
VLOOKUP inside an ARRAY to search another Google Sheets book
I have a document 'A' where I have a formula in a 'SEARCH' tab to search for a value from another 'ENTRIES' tab in Google Sheets based on a cell reference written by the user in the same 'SEARCH' tab than the formula.
If I duplicate the 'SEARCH'…
deags
- 494
- 1
- 6
- 21
2
votes
1 answer
How to populate a VLOOKUP with a dynamic range in Google Sheets?
I have a file that needs to look up the team name (on a tab called "Parse") of an employee on a tab called "Roster". This can be done with a simple array Vlookup, however, the issue is that each week, we add a row to the Roster tab because…
Nick Taylor
- 45
- 6
2
votes
1 answer
Converting formula to ARRAYFORMULA issues with SUM and INDEX
I have a scoring spreadsheet for a competition I'm working on. Competitors' place/rank are converted into points towards the overall series based on a chart of corresponding values. For ties, the sum of the points covered by all of the tied places…
Josh Lowy
- 35
- 4
2
votes
1 answer
How to populate blanks in a column with last non-blank cell
I have a spreadsheet of data on Google Sheets where one order is spread over several rows, however, only the first row contains all the information. I need a way to copy the last populated cell down into all of the blanks.
So it looks like the left,…
barbarajohnson
- 47
- 5
2
votes
2 answers
Google Sheets LOOKUP unable to find lookup value even if there is
=lookup(A4,'LTO Renewal Record'!B2:B20,'LTO Renewal Record'!C2:C20)
Above code is suppose to return a date value. However, it gives me an error saying "Did not find value "my value" in LOOKUP evaluation." even though it is there.
Here's a link of…
Kelvs
- 97
- 2
- 14
2
votes
2 answers
Formula to filter unique rows with highest value in Google Sheets
I have a sheet that automatically pulls in social metrics from multiple accounts a few times a day, because of this I often have multiple lines of data for the same post. How do I filter the rows in a new sheet so that only the post ID (column F)…
KArnold
- 23
- 4
2
votes
1 answer
Arrayformula to pull the minimum value in a column based on cell contents of another column
I'm trying to find a way to get my minifs formula to work in an arrayformula in google sheets.
I have two sheets - Summary and Data. On Data, I have a list of names in Col A that duplicate. Col B has a list of labels that correspond to dates in Col…
Lindsay
- 23
- 3
2
votes
1 answer
'No match' message in Google Sheets Vlookup results for cells with no data
Based on (Search a value from another tab/sheet in google sheets based on cell reference), I have 2 tabs/sheets in Google Sheets, one that gathers data from a Google Forms and the other is a Search sheet.
The example is here (It's the same one used…
deags
- 494
- 1
- 6
- 21
2
votes
1 answer
Is there a way to conditionally format data validated entries to change the values within the cells themselves?
I have an attendance sheet I'd like to edit that has data validation pertaining to credit applied towards the overall attendance percentage, with a 1 meaning the person was there, .5 for late, 0 for calling off appropriately, -0.5 for calling off…
bynary
- 89
- 7
2
votes
1 answer
Custom order (not alpha or numeric) of query results
Is it possible to create a custom ORDER BY function in a google sheets QUERY?
In this scenario, I don't want the results to be alphabetical nor numeric, but rather a custom order based on a predefined category list that is actually in a separate tab…
TC76
- 860
- 1
- 8
- 17
2
votes
2 answers
Is there a way to filter and return results for the unique of one column, with conditions of another?
Question
For the data below, is there a way to return results —for each order in col B— either:
If the most recent status [col D] for an order (ex. for order 10021) is closed, then return that row.
If not, return every row since the most recent…
saadya
- 35
- 7
2
votes
1 answer
Is there a way to link data by names in Google Sheets?
I am using Google Forms and Sheets to create a way of tracking services including time for some of our students. I have the forms linked to a Sheet and am able to pull the "Clock In" data and "Clock Out" data into a single sheet. My issue is: when I…
MB32
- 33
- 4