Stack Overflow
Stack Overflow

Questions tagged [gs-vlookup]

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].

501 questions
4
votes
1 answer

Performing lookups with merged cells in Google Spreadsheets

Given a set of multi-dimensional data represented in a Google Spreadsheet: A | 1 | x A | 2 | y A | 3 | z It is pretty straightforward to do a lookup on multiple values using the FILTER and INDEX functions. Doing a lookup for A2 would result in…
jheddings
  • 26,717
  • 8
  • 52
  • 65
3
votes
1 answer

Google Sheets How to Filter Column Based on Cell Reference

Background I have a sheet I use for managing software installed in computer labs at our college. Column A contains a list of software titles. Row 1 contains all the lab names, and all the cells in between contain a status of whether or not the…
veen1981
  • 33
  • 4
3
votes
1 answer

Google Sheets function to group and concat rows

Sample sheet: https://docs.google.com/spreadsheets/d/1AeP0sxDi0-3aaesUdCNTKfricIimjTMFaKO-FX9_g50/edit?usp=sharing I am trying to find a formula that will group a table on a column and concat the values from all the rows in another column. For…
IMTheNachoMan
  • 5,343
  • 5
  • 40
  • 89
3
votes
2 answers

Vlookup with multiple matches in Google Sheets

My data looks like: id state value 1 abc x 1 bcd y 1 def z 2 abc p 2 bcd q 2 def r 3 bcd m 3 def n I am trying to vlookup the value for id 1, 2 and so on, but where the…
Bruce Wayne
  • 471
  • 5
  • 18
3
votes
1 answer

How to use vlookup with values that aren't numbers

I am trying to use vlookup to find the sales rep with the highest revenue within my data set. I am getting an error message saying the value being found is not a number (which is the sales rep's name). Not sure how to fix this issue. I have read…
Austin Farmer
  • 125
  • 1
  • 1
  • 8
3
votes
2 answers

Is it possible to use arrayformula to copy the values above if the cell on its left is empty?

I'm trying to populate a column (Cell C2) with the value of the cell in the column to its left (Cell B2) if B2 is not empty; if B2 is empty, then C2 equals to C1. If B3 is not empty, then C3 equals to B3; if B3 is empty, C3 equals C2. I try using an…
CelestialBeing
  • 37
  • 3
3
votes
1 answer

Google Spreadsheet vlookup in validation drop-down

I want to operate with ids, and not with data that related to id. For example: Sheet details has this data: | A | B | 1 | category_id | category | 2 | 0 | Web | 3 | 1 | Mobile | Sheet John Cena has…
Roman M. Koss
  • 970
  • 1
  • 15
  • 33
3
votes
3 answers

Sum values based on row value and column header

We have a Google Sheet doc which contains a date column with each date as a row value, and also multiple columns (some of which have the same name) and we want to sum the values in the cells where the row is a specific date, and the column has a…
Matt Scott Gibbs
  • 55
  • 1
  • 2
  • 6
3
votes
1 answer

Finding string text in cell using VLOOKUP

I have a problem regarding a VLOOKUP formula in Google Sheets. When I use it in Excel or OpenOffice Calc it works like I need but it's somehow different here. My problem is that I need to find WORD that is amongst other words in some unknown cell in…
saint337
  • 33
  • 1
  • 8
2
votes
2 answers

Formula to calculate sum of items in google spreadsheet

I have items in a row (item 1, item 2, etc...) and prices for every item in a column, can I write a sophisticated formula which will calculate the total for every person, without manually entering all intersection? | Name | Total | item 1 | item…
Anatoly
  • 5,056
  • 9
  • 62
  • 136
2
votes
1 answer

Get value from another google sheet

The formula should be placed in C7: ={"SCHEDULE";ARRAYFORMULA()} Need a formula that will search the name of the user from INDIRECT(J6) and find the Time from another sheet (1) depending on the Sched sheet name in cell B3 and (2) based on what day…
KB John
  • 89
  • 5
2
votes
1 answer

Dynamic dropdowns, INDIRECT, multiple rows

So I have this "Google Sheets App" in one row. It has 2 interactive dropdowns (Dropdown B options appear based on Dropdown A), and some fields which change based on the option. I finally got all that to work using ARRAYFORMULA(INDIRECT), VLOOKUP,…
dantevn5
  • 37
  • 9
2
votes
1 answer

How do I fill down a column, copying the cell above, unless the adjacent cell has a value, then copy that value?

I'm trying to clean up a data table, and I want to fill column B with values, based on the last non-blank value in column A. This formula works, if copied down in column B, but breaks whenever I insert a blank row, which I will need to do. I'm…
kirkg13
  • 2,955
  • 1
  • 8
  • 12
2
votes
1 answer

Concatenate cell values if they have a similar value in another cell

I need to concatenate the city names that a person has been to into another cell but they have to be repeated every time the name of the person comes up. I tried using COUNTIF but couldn't get me anywhere. I don't wanna use VB code; just…
Iman Ghavamabadi
  • 47
  • 6
2
votes
2 answers

Google Sheets Index Match Not Found

Working on a spreadsheet to list inventory items for sale in bulk. Wanting it to automatically generate a "Condition Note" for each item based on it's SKU and Category. Have a sheet named "Description Table" that has Condition Notes arranged by…
lostest
  • 45
  • 1
  • 7
1
2
3
…
33 34