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
-1
votes
3 answers
If found in Column A, display entire row
I am trying to do a lookup but VLOOKUP does not seem to be the answer...maybe an INDEX and MATCH formula but I can't wrap my head around it.
Anyway, I have two tabs, one with data, and the other one will pull parts of the data from the first tab. …
Chris
- 101
- 7
- 22
-1
votes
2 answers
VLOOKUP on continuous form
On K250 cell I've this put a formula so that when user submit data via form formula will work.
=VLOOKUP(F250,Available!$C$1:$E$72,3,false))
But problem is when someone submit a form, row K250 is getting down as K251 & submitted form taking palce…
Tanzil
- 1
- 1
- 1
- 3
-1
votes
2 answers
Vlookup or Indexing using google apps scripts
I have a spreadshseet (Sheet1) in which the Data is there from Col A to Column D, and in another sheet (Sheet1), again the data is there from Col A to Col W, in which the Col F data has some matching with column D.
What i am seeking for:
I want to…
user1465668
- 1
- 1
- 3
-2
votes
1 answer
Gsheet - Split Values of Cell
I'm using
=importjson to import this API ("https://bitmax.io/api/pro/v1/depth?symbol=RUNE/USDT")
in a cell of Gsheet documents.
The result is this:
Is there a way to split the value in a cell in this way?
This way to format the result of API…
Pierandrea
- 13
- 2
-2
votes
3 answers
Vlookup all the values matching the search term instead of just one.
So the following formula returns only the first value from the range. I kinda need all the matching search results indexed instead of just 1.
=Vlookup("*" & B3 & "*",A:A,1,0)
SPREADSHEET LINK
rockinfreakshow
- 15,077
- 3
- 12
- 19
-2
votes
2 answers
Look up value by "submission number" return "name"
I have one sheet, with values such as this:
Sheet A
and another sheet with values like so:
Sheet B
What I would like to do is search in the Sheet A by "Submission Number", i.e. the values in column A, I want to search there using the values in…
smatthewenglish
- 2,831
- 4
- 36
- 72