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

Wrong results in Google spreadsheets Lookup functions (vlookup, hlookup, match)

The following spreadsheet demonstrates a very odd behaviour of Google Spreadsheets Lookup functions. I've used these functions many times without any problem. Can anyone confirm it happens on their side as well? Example doc:…
zstolar
  • 461
  • 1
  • 4
  • 9
19
votes
1 answer

Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block

Sheet1 has columns A to D where A contains a unique record key. On Sheet2 I want to rearrange the data, against my own sort order. Colum A contains my own custom ordered record keys. What I have done upto now on Sheet2 is; I'm calculating the record…
Riyaz Mansoor
  • 685
  • 1
  • 8
  • 22
19
votes
4 answers

Google Drive Spreadsheets: Combining IF and VLOOKUP

I'm trying to work out a formula for combining an IF statement and a VLOOPUP. Basically, I want the formula to return a value if a value was found through VLOOKUP, or to return something else if not found... I have experimented with…
user2761030
  • 1,385
  • 2
  • 20
  • 33
17
votes
2 answers

Google Sheet pulling data from another spreadsheet if match

So I'm stuck with something. I have two spreadsheets, column A on each are similar but not identical, some values are on one spreadsheet but not the other. Is it possible for me to pull data from spreadsheet 2, based on if column A has a matching…
Ed Jones
  • 321
  • 1
  • 2
  • 11
14
votes
4 answers

What is an equivalent for INDEX in ARRAYFORMULA?

I have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values based on row and column indices. How can I do that in an ARRAYFORMULA like this?: =ARRAYFORMULA(INDEX(x!C2:C, F1:F)) x is the sheet holding…
Cata
  • 478
  • 1
  • 5
  • 13
12
votes
1 answer

Google Spreadsheet Check From What Cell VLOOKUP() Returns

Is there a way to return the cell from which VLOOKUP() gets its value? For instance: ________A_____|__B__| 1 | Mouse | 1 | 2 | Keyboard | 2 | 3 | Headset | 3 | 4 | HDD | 4 | =VLOOKUP("Mouse",A1:B4,2,FALSE) --would return…
user2706406
  • 123
  • 1
  • 1
  • 4
10
votes
3 answers

How to use ARRAYFORMULA + FILTER within Google Spreadsheet?

I have a Google spreadsheet with basically a dictionary of key/value pairs. Keys are unique. In a second sheet I need to add one or more rows for every key in the dictionary with some data. In this very sheet I'd need to also report the proper value…
EnzoR
  • 3,107
  • 2
  • 22
  • 25
9
votes
2 answers

How to calculate the sum of VLOOKUP with two criteria?

I'm looking for a clean(er) way (than using SUMIF with a third row) to calculate the sum of the results from, say, a VLOOKUP that checks both the first and the second row for matching criterion. So, given the Transaction spreadsheet, I'd like to…
Tim Metcalfe
  • 187
  • 1
  • 2
  • 10
6
votes
3 answers

ArrayFormula with GoogleFinance dynamic date

First of all, i'm not a powerful sheets user :) I'm trying to use GOOGLEFINANCE to calculate amounts in multiple currencies. I use this formula: =IF($A2; IF( $C2:C; $C2:C; IF( $D2:D; …
valentin.mu
  • 93
  • 1
  • 8
6
votes
2 answers

lookup country name and return flag image to cell in Google Sheets

I have a country list of 245 countries. Is there any way I can use a VLOOKUP in Google Sheets to import their respective flags? I was thinking of potentially using a resource such as Wiki or http://www.theodora.com/flags/ but not sure if I can?
user1721451
  • 247
  • 6
  • 15
6
votes
2 answers

VLOOKUP within IMPORTRANGE

I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP: =importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false))) I get a general error. Does…
Luca
  • 848
  • 1
  • 14
  • 33
6
votes
2 answers

Excel to Google Sheets - Error: Formula parse error

I have created a simple league spreadsheet in Excel but when I try and use it in Google Sheets I am getting formula errors. This is the first time I have used Google Sheets and I would like to use it to make my league public. An example of a invalid…
2ne
  • 5,766
  • 9
  • 30
  • 51
4
votes
2 answers

How to add and highlight rows on input of particular column in Google Sheet

In the attached google sheet. Google Sheet - https://docs.google.com/spreadsheets/d/1KxqaI-GYWur0Knt_bShI0GURucqU_cawu_sCoG_8Xlc/edit?usp=sharing I need to execute the following two operations on input. Add same number of rows against which ID if…
Sophia Wilson
  • 581
  • 3
  • 16
4
votes
3 answers

VLOOKUP returning wrong row

I have a fairly simple lookup table: The formula I have in B6 is: =VLOOKUP(A6,C1:D4,2) So I would expect it to return 1, not 4?
Bill
  • 3,584
  • 5
  • 35
  • 47
4
votes
1 answer

How can I use VLOOKUP as a calculated field in pivot table in Google Sheets?

I have numbers coming in every day from a variety of partners using a nightly report form. I have a pivot table for this data to summarize various counts. I have a list of goals for each partner in a separate tab. I would like to create a calculated…
Tomulent
  • 531
  • 2
  • 5
  • 20
1
2 3
…
33 34