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
2
votes
1 answer

Filter column with condition Google Sheets

I'm using Filter function using Google Sheets but can't use it the way I want, it has been 3 days... Basically I have Sheet 1 with a column "e-mail" and column "Lead ID". The Sheet 2 has the same "Lead ID", but it's filtered. Meaning, Sheet 1 it'…
Renato Pimpão
  • 135
  • 2
  • 11
2
votes
2 answers

Google Query Language - Adding column on a group By

Excuse me this is my first post. I tried to make a nice table like others do but I struggled with the formatting Please consider the following spreadsheet: table image Google spreadsheet:…
Mellon Symphonic
  • 23
  • 6
2
votes
2 answers

Arrayformula to find next value for criteria in Google Sheets

I have Form Responses tab in my sheets where I collate information containing starting datetimestamp, number and name. I want to create an arrayformula that will fill last column with datetimestamp for the next name entry in the dataset. I want to…
Piotr Szpitalny
  • 23
  • 3
2
votes
1 answer

Vlookup doesn't work with multiple conditions

Can anybody help me, I don't know where the issue is. I get the following error message: "VLOOKUP evaluates to an out-of-bounds range." The range to search in is on another sheet.
Vidomina Sangre
  • 55
  • 10
2
votes
1 answer

Import data from another sheet using ID but only some columns

I have a google sheet like this : And another one like this : I want in the second google sheet to pull data from the first sheet that matches those IDs I have tried index & match, vlookup, lookup but none of them got me to my point especially…
biahuosisnice
  • 49
  • 6
2
votes
2 answers

Select "Time Description" based on current date and time in Google Sheets (VLookup, Query)

I am trying to use VLookup or QUERY to extract a day and time description based on the current date and time. I thought QUERY may be the best here, but VLOOKUP seems to be the best solution perhaps. Is it possible to extract the date from between…
Gracie
  • 896
  • 5
  • 14
  • 34
2
votes
1 answer

How can I query multiple columns and only return the values that are selected elsewhere?

I can't embed images yet, but I have included them as inline links. In Google Sheets, I have built a set list builder for my band. Currently, I have dropdowns that allow the user to select a song from our song list. I want these dropdowns to be…
Skyler
  • 21
  • 2
2
votes
2 answers

A formula to look up values in column depending on dropdown

Please see the link to my Google Sheet. Google Database This is an image from my 'Planning' sheet: In cell A6 of the 'Planning' sheet is a name that is selected by dropdown sourced from column A5:A17 of the 'Qualifications' sheet. In cell B2 of…
McChief
  • 423
  • 1
  • 3
  • 18
2
votes
1 answer

get values from other cell from other sheet if match value match with other cell

I have data on my sheet. Now I want to get data from my sheet1 to sheet2 if sheet1 Column A value match with sheet2 column A I want to copy Column B in sheet 2. Sheet one Column A | | Column B ================================= Hello …
hardy
  • 537
  • 1
  • 5
  • 19
2
votes
1 answer

How to reference to previous matching record using arrayformula?

I have a project spreadsheet, with project managers entering current progress status for each project for each month where there was some activity. So the columns A B and C are filled, I need to be able to figure out the column D using…
Mara
  • 371
  • 5
  • 16
2
votes
1 answer

Finding closest greater from a filtered range

I have a sheet with information regarding the operation time of two machines. It has three main columns: "A" is the number of the machine; "B" is the starting time and date of operation; and "C" is the ending time and date of operation. I'm trying…
zfg
  • 195
  • 1
  • 1
  • 8
2
votes
1 answer

Vlookup formula in Google Sheet

I have a google sheet which I want my colleague to fill the data manually to cross-check whether there is any difference in the system and the manual notes. I have the data from the system in the second sheet of the same google sheet. I want the…
Sandeep
  • 671
  • 2
  • 7
  • 30
2
votes
1 answer

How to use vlookup formula to look at two values before displaying a value

I want my vlookup formula to first look for a date (column A), then look for a person's name (column B), then display the value of column C. I can get the formula to display the person's name (column B) but not sure where to go from…
Austin Farmer
  • 125
  • 1
  • 1
  • 8
2
votes
2 answers

Translating each result row of a Google Sheets QUERY operation via VLOOKUP

I have the multi-column results of a QUERY in Google Sheets, where I want to translate the strings in one column based on a lookup table in another named range. I can accomplish this indirectly with an additional VLOOKUP call, but I'd like to do it…
Joost Schuur
  • 4,417
  • 2
  • 24
  • 39
2
votes
1 answer

How can I dynamically import value from the same workbook using a formula

I'm trying to employ ArrayFormula to import value from another sheet inside the same workbook, but I can't find anything that works except ImportRange, and that requires the current workbook's URL which is tedious. I have two sheets set up: "Sheet…
bbss
  • 19
  • 3
1 2
3
…
33 34