Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
So I'm stuck with something. I have two spreadsheets, column A on each are similar but not identical, some values …
google-sheets google-sheets-formula gs-vlookupI'm trying to work out a formula for combining an IF statement and a VLOOPUP. Basically, I want the formula …
google-sheets gs-vlookupI'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a …
google-sheets google-sheets-formula google-sheets-query gs-vlookup importrangeI'm looking for a clean(er) way (than using SUMIF with a third row) to calculate the sum of the …
google-sheets gs-vlookupI have a Google spreadsheet with basically a dictionary of key/value pairs. Keys are unique. In a second sheet …
google-sheets array-formulas gs-vlookupThe following spreadsheet demonstrates a very odd behaviour of Google Spreadsheets Lookup functions. I've used these functions many times without …
google-sheets google-docs gs-vlookupSheet1 has columns A to D where A contains a unique record key. On Sheet2 I want to rearrange the …
google-sheets gs-vlookupI have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values …
google-sheets google-sheets-formula array-formulas gs-vlookupIs there a way to return the cell from which VLOOKUP() gets its value? For instance: ________A_____|__B__| 1 | Mouse | 1 | 2 | Keyboard | 2 | 3 | …
google-drive-api google-sheets spreadsheet gs-vlookup