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

Compare two sheet columns and copy data to first Sheet

I'm trying to find out the formula for matching CODE 1 between Sheet1 and Sheet2, then, copy 'Original','Lost' and insert 'Total 2019 Order' columns into Sheet 1 by corresponding CODE 1, The google sheet is…
Mike Mah
  • 11
-1
votes
1 answer

How to VLOOKUP from bottom with IMPORTRANGE

Main Sheet: https://docs.google.com/spreadsheets/d/1j71MW_rgbWFxaldl4j4Ww3a22QMRZpy_u2NFrI1jjak/edit?usp=sharing Formula in C155 IMPORTRANGE Sheet:…
Peter Chabot
  • 139
  • 1
  • 9
-1
votes
2 answers

Comparing attributes from 2 sets

I have 2 sets of data, let's say, Workers and Platform. Both have attributes, say, Drilling, Grinding, Hammering. I need a way to compare, in Excel, the attributes for each element within both sets. For example, if Platform A requires Hammering and…
Baldomero
  • 61
  • 7
-1
votes
2 answers

Google Sheets VLOOKUP using arrayformula not working

I am trying to populate rows of data from another sheet using VLOOKUP and ARRAYFORMULA. Here is the data where I am using arrayformula: G2 has the formula: =arrayformula(if(ISBLANK(E2:E),"",VLOOKUP(E2:E,'Product List'!$A$2:$C,2)*F2:F)) And here is…
Wes Foster
  • 8,770
  • 5
  • 42
  • 62
-1
votes
2 answers

DGET with multiple (compound) keys returns #NUM! error

What is the logic of the DGET function with multiple criteria keys? I have made two small examples to investigate: Case 1: we get a value by Date type key only - it works fine. Case 2: same data, but we add a String type key. Here we have an…
Александр Ермолин
  • 1,145
  • 1
  • 10
  • 17
-1
votes
2 answers

VLOOKUP with if statement (get price based of id)

Currently, I have a single sheet which contains: ID, ProductName, Price I need help with the formula so that in another tab (Google Sheets) the way to get a price based on ID(or product name) if I select for example A1 and will change product ID in…
Oksana Ok
  • 515
  • 3
  • 7
  • 19
-1
votes
1 answer

Updating column based on the multiple conditions ref another workbook

I am stuck at this the array formula for which I would like multiple conditions. Here is the main workbook MO Listing to update the 'Status' column referring to this workbook
Wilson Wee
  • 21
  • 3
-1
votes
1 answer

How does one reference another sheet using a string from another cell?

This doesn't seem to work for me: VLOOKUP(A4,INDIRECT(A4&"!")A1:Z40,5) What can I change? I get a formula parse error. I have fiddled around with quotes and such in the INDIRECT function, but it isnt working to draw the text "Arizona" I want from…
Zachary Donnini
  • 39
  • 1
  • 6
-1
votes
1 answer

Array formula is misbehaving

I want to add an extra column which takes a value with a VLOOKUP from another sheet and adds the value to each cell in that column if the value's ID matches an id from another column in this spreadsheet. I have partial success with my formula. It is…
Robert Ross
  • 1,151
  • 2
  • 19
  • 47
-1
votes
1 answer

Lookup data from two ranges and if text matches, then assign numeric value

I am trying to calculate points in a Formula 1 racing league. I'm having trouble with a bonus 15 points if a constructor qualifies 1st and finishes the race 1st. The issue is there could be two different drivers who do this. For example. As you can…
user1721451
  • 247
  • 6
  • 15
-1
votes
1 answer

Google Sheets VLOOKUP/IF

Plain english: Output 1 (yes) if the same ID# has more than one entry in the sheet within 5 minutes. Example sheet, feel free to change anything: https://docs.google.com/spreadsheets/d/184jhnAmu63HSYl69prnAP7xo7j2PFvzjrWgDS4zj7dU My thought is to…
Matt
  • 11
  • 3
-1
votes
1 answer

Vlookup or Hlookup or something else?

On a single table of musicians and instruments, musicians will be playing multiple instruments and multiple musicians may play each instrument. Ultimately, I want to collect two lists: Who is playing each instrument and What each person is…
mrcaplan
  • 3
  • 1
-1
votes
1 answer

Lookup and calculation with mulitple criteria also based on a cell value

I'm trying to create a spreadsheet that will allow me to quickly calculate the amount of time my trains were delayed on a daily basis. I need a formula that will check for all trains on a particular route after a planned departure time (written in a…
Oli Kingston
  • 1
-1
votes
2 answers

reference cell via two partial matches on another cell

I need to match two conditions on the cell Name and add the price information into cell price if both condition match. In other words, if Name contains both conditions, get the price. I tried different approaches using QUERY, SEARCH; FIND; VLOOKUP…
Christian Borck
  • 1,812
  • 1
  • 13
  • 19
-1
votes
1 answer

GoogleSpreadsheet, VLOOKUP with an empty cell

I have this matrix for key/values 1 | one 2 | two 3 | three | none and the VLOOKUP cell =VLOOKUP(A10,A1:B4,2,false) If the cell A10 contains any number from 1 to 3 it is ok, but if the cell A10 is empty the VLOOKUP returns: "#N/A" -> _"Error:…
fguillen
  • 36,125
  • 23
  • 149
  • 210
1 2 3
…
33
34