Questions tagged [vlookup]

For questions about the VLOOKUP spreadsheet function that allows the mapping of a selection (a ‘search key’) to a result in the same row of a table (‘range’ or ‘array’).

Filter by
Sorted by
Tagged with
0
votes
0answers
40 views

Calculate number of days between dates across multiple rows

I am trying to find a way to create a pivot table in Google Sheets that lists the years as rows, the countries as columns and the number of days lived in each country as the values. I think the way to ...
0
votes
1answer
28 views

In Google Sheets, can you repeatedly autofill until next non-blank cell or until a value in another column changes, whichever comes sooner?

I'm trying to format a CSV file that contains a huge list of products (8000+) that are on separate rows but need all the fields to be on the same row. The trouble is that some of the cells are ...
0
votes
2answers
39 views

VLOOKUP or MATCH with IF GREATER THAN

Is it possible to automatically pull a list of students with 2 or more absences onto another tab in Google Sheets? In the following link, the first tab has a list of students and how many absences ...
0
votes
2answers
65 views

Vlookup when multiple values in one cell

I want to find a short solution to find the matching Korean term of column A in "English" from sheet "Korean." For now I have split column A and then used Vlookup for each value, ...
0
votes
1answer
25 views

Offset a Vlookup across multiple sheets

I recently received help on creating a formula to fill in data on a Google sheet for customer orders, this goes between sheet1 (master) and sheet2 (selected data only, depending on the reference cell)....
0
votes
0answers
52 views

Array Formula Problem - How to Fill In Blank Rows with the Same Value before a Breakpoint which advances to the next letter

I have a Google Sheet which is grouped into segments of a TV show. So there's an A segment and then a B segment and so on ... I have allocated two columns to provide two different timing functions (...
1
vote
2answers
31 views

How to SUM the VLOOKUP results based on condition in other column using ARRAYFORMULA?

I would like to sum all the costs based on the products purchased between specific dates. =SUM(ARRAYFORMULA(IFERROR(VLOOKUP('Purchased List Table'!B2:B,'Pricing Table'!A2:B,2,0),""))) With ...
0
votes
0answers
8 views

Check if Column contains value, when found return sum of two cell

I'm using a Google Drive spreadsheet to my warehouse. I need to find a value (description) of a cell from a column and if I find it sum the quantity of this description + quantity of my warehouse. ...
0
votes
1answer
139 views

vlookup with multiple output and combining filter() with arrayformula()

I have 2 sheets : shot and deadline. https://docs.google.com/spreadsheets/d/1drNUQVtAxd0HU4QCVSKJSsKHoanE735n8HsjkYpYiGs/edit?usp=sharing This is my shot sheet : and this is the deadline sheet : So ...
0
votes
1answer
38 views

Need Script changed to a different page in the same sheet

I have a script on a sheet in my Google Sheets workbook that emails when a cell changes to "TRUE", but the cells in question are a vlookup to another sheet in the workbook. This works in the ...
0
votes
0answers
8 views

vlookup calculates too early, searches for the value "" instead of for the value that will later populate

I have a user interface , then a list of =unique() functions populating an inventory list. Finally, multiple instances of an ingredient are summed up into a concise list. A final list of vlookups, for ...
2
votes
1answer
66 views

Using Vlookup with Dates

Here's the set up to the problem I'm having. I have a column of dates and a column of truck numbers. I'm trying to use VLOOKUP to find what truck numbers correspond to the dates. There are multiple ...
0
votes
1answer
38 views

Google Sheets VLookup Help

So, I am trying to use the VLookup function to find the value of a cell that corresponds with todays date and return that cell information. However, if there is no date given for todays date, then I ...
0
votes
0answers
46 views

Google Sheets data autofill issue =Query? =Vlookup?

I'm attempting to autofill a budget spreadsheet, based on a paychecks paydate, filling the bills due that pay period. Bills 1-30 Pay Dates ranging from 1-30 I'm hoping to be able to plug in the Pay ...
0
votes
0answers
19 views

Google Sheets lookup value

I am trying to figure out how to get the data from the data validation box in D13 and I 11 to return the intersecting data from the Formulas Sheet. what I am doing is creating a sheet so that when the ...
0
votes
0answers
17 views

VLOOKUP (PROCV) It's not returning the same value in the next line

I have a specific "ORDER NUMBER" that shows up around 10 times with different "MONEY VALUE", so I did a dynamic table to group up all the "MONEY VALUES" for that "...
0
votes
1answer
54 views

Using VLOOKUP with pivot table - OR - another way to aggregate data

My sample is here: https://docs.google.com/spreadsheets/d/1j9pRECnAKtKtvAfhMvLv93-u6_kwIrFZg3RY3jSkpkU/edit?usp=sharing I am trying to aggregate the last date that each "familyID" was ...
1
vote
1answer
105 views

Google Sheets: VLOOKUP formula for a multi line cells range

I have here a sample project, where columns A to C are in FORM RESPONSES TAB/SHEET and columns D and E are in RECORDS TAB/SHEET. In the RECORDS I have a list of names, in alphabetical order, and a ...
0
votes
1answer
22 views

Find given time and date in named range

I have a Google Sheet with my wife where we both enter our upcoming events. They are included in named ranges and passed to the main sheet where the information is displayed. For example, I enter in ...
0
votes
0answers
20 views

Query - Procv with 2 Conditions

I'm trying to do a query with 2 conditions: =ArrayFormula({"User"\A1:F1;QUERY(SE.ERRO({PROCV(B2:B&F2:F;G2:H;2;FALSO)\A2:F});"Select * Where Col1 Is Not Null Order By Col1 Asc")}...
1
vote
0answers
29 views

How can I use a dropdown menu in Google Sheets filter out data and populate cells for a an expense tracker?

I have created a personal expense tracker (budget) that uses google form responses and categorizes them by fortnights and expenditure categories. This has been successful on a sheet called 'Yearly ...
0
votes
1answer
47 views

Look up rate for specific person in effect on or after a date

In this Google Sheet, I have one sheet, "Transactions", with a rate entry that should be auto populated from a table in the "Rates" sheet. The formula should look up the rate for ...
2
votes
1answer
55 views

Searching cells and pulling values in Google Sheets?

sorry for the vague title but I'm not sure how exactly to describe this. I've created a spreadsheet and used the Coinmarketcap API to pull lots of data, here's the relevant part: From another sheet I ...
0
votes
1answer
18 views

Why does VLOOKUP find a match in a sequence of dates when there is none?

I am working on spreadsheet that works with a school calendar. I have a sequence of dates that is a list of Wednesdays. I am trying to do a VLOOKUP on it to find out what type of day a specific date ...
0
votes
1answer
81 views

Copy data based on date to another cell but other column date is not exact match

I want to match the dates in Column A to the Closest date in Column E (if a date in column A doesn't match to dates in Column E then I want to return the next available date in Column E and I've done ...
2
votes
2answers
751 views

Categorize text in Google Sheets based on matching partial text in the Category index

I'm looking to match, with VLOOKUP, part of the words in a column in the main sheet to an index of keywords/categories where partial words are stored for ease in another sheet. Here's an example ...
1
vote
1answer
113 views

Search multiple columns for one value

This is roughly what my table looks like: A B C D E F Name |Ingredient 1 |Ingredient 2 |Ingredient 3 |Ingredient 4 |...
0
votes
1answer
31 views

How to assign country based off list of either provinces or states?

I have a list of names and locations. Most of the locations include the name of the province or state. Some only include country names, some include state abbreviations. I also have a list of ...
1
vote
1answer
480 views

Sheets - Lookup most recent entry based on unsorted date value

Spreadsheet Im working on: https://docs.google.com/spreadsheets/d/1rTzdmKVMqD8sz1D639y5qgvXNBcWaAuBaQOAmwJXdA4/edit#gid=0 I need a formula that returns the Comment for the Domain that equals the ...
0
votes
0answers
24 views

Go into "Display" tab, click a name off the drop down list, and view that individual's data

I have 3 tabs. "Timestamps" "Techs/Locations" and "Display." My form timestamps when an employee clocks in or out. I have created two separate columns to carry over the ...
0
votes
1answer
33 views

How to replace or substitute one column of data with their corresponding value from a list

I'm trying to replace a column of data (Prodct SKU) on one sheet (a) with the corresponding value taken from 2 columns on sheet (b) (Product SKU & Product ID). I've attached the spreadsheet to ...
1
vote
1answer
41 views

Using a query and tick boxes to auto fill another tab

I'm new to this and I'm racking my brains over how to get this to work, I can do basic IF & Vlookup but I believe I need the merge the 2 for this one. Is there a formula I can use on the "NLN" ...
2
votes
1answer
231 views

How do I populate cells (with formulas) from one google sheet into another while using one as a search key for the other? If C=This, State D

I'd like to populate Columns C and D in an entirely new spreadsheet, where Column D still auto-populates the cells just as it does in the original/first sheet (as it does in the photo attached inside ...
1
vote
1answer
67 views

Formula to find the cell in column C where a value in column A = a value in column E

I'm trying to create a formula in a google sheet to find the value in the C column where the value in the A column is equal to the value in the E column. E.g. Column E = 1 in Row 9-16 and Column A = ...
1
vote
1answer
415 views

Google Sheets Inverse (or Reverse) LOOKUP ... is this possible?

As far as I can tell, all LOOKUP functions require you to know a specific search_key (like a column or row header) in order to search for and retrieve a relative value. Inversely, is there a way to ...
1
vote
2answers
364 views

Adding 1 to a Cell with VLookup

So this is my first time trying to write a script, and the sheet I am working on is here. The script I'm trying to run would allow me to push a button and have it use Vlookup to add 1 to a cell in ...
0
votes
1answer
34 views

Indirect formula to add table field to vlookup formula

So I have to get a price based 3 variables Diamond size Diamond quality Diamond Shape So I made tables depending on shapes This formula is working Diamond size = H11 = 1 Diamond quality = $K$3 =...
2
votes
2answers
512 views

Array formula with index match to return array of matches

I've been working at this for a bit. I have tried many times different formula combos, using VLOOKUP to using INDEX & MATCH, even with an ARRAYFORMULA. What I'm attempting to do is match a ...
1
vote
1answer
53 views

Help Sorting Data

I have a spreadsheet that I'm using to keep track of stats for players in a league. This is the link: https://docs.google.com/spreadsheets/d/193GxNzaX4-bGrNB8eT4vhqAOKhUrChRDgq-HYVU_Txk/edit#gid=...
1
vote
1answer
443 views

Google Sheets calculate average on variable number of non-adjacent columns?

A Google Sheet is being used to insert markings for students tests. When a single test is done by students, teacher assigns multiple grades for it. For instance, one marking for writing, one for ...
2
votes
1answer
73 views

How to find, out of many days, 1 day that is most profitable on Google Sheets?

Ok, I've been looking for this type of formula but not finding it. So here I am asking for help. I'm a day trader on stocks and I want to analyze my performance. For example: +-----------------+-----...
2
votes
2answers
12k views

"Error Did not find value '____' in VLOOKUP evaluation."

Please see my public spreadsheet here: https://docs.google.com/spreadsheets/d/11RMN7uN_woEQVzlDEkX6vSARTCGYYBjWs11ZDU-6Shc/edit#gid=1276951687 My goal is to get the Location Code from tab 1 into tab ...
1
vote
1answer
933 views

Google Sheets - If cell contains text that matches text from a column, return another cell

https://docs.google.com/spreadsheets/d/1GG7ekrD6CxxpowrRDm9DMvv3xHdvtAa8MHYCk4gI4D4/copy 1) If D10 (or I10 or N10) matches an exercise from the corresponding column to the right, return another cell (...
1
vote
1answer
29 views

Make cell range appear in different position to VLOOKUP?

I want to use VLOOKUP to search the highest value in a given range, and report to me what day it's the highest. Example VLOOKUP for my actual data set in case if it matters: =VLOOKUP(MAX(A3:A1001),...
2
votes
1answer
104 views

How to automatically calculate averages from ID in Google Sheet?

I've been looking around for an answer but couldn't find what I was looking for. The problem is that I want to use an arrayformula, but can't figure out a dynamic formula that: Looks at the unique ...
2
votes
1answer
1k views

How to check if the values of two cells exist in two columns of another sheet

I am trying to make a class attendance system where the student checks in by submitting her name into google forms. The final result will be displayed in Google sheets by marking a check box after ...
1
vote
1answer
130 views

Google sheets Xlookup dont work but need results in table the max date on the condition of userlist

Need some help with some data processing. Link of the sheet Example - I need on : Page-2-Seznam članov > Coloumn C : It needs to be the max dates. The function need to search on the liste the ...
0
votes
2answers
5k views

In Google Sheets I need to find a string and return true/false, or even a count into a cell so I can perform an action

In my example i have a column with Names of signs we product in our sighshop and I need to be able to isolate similar named signs So say I need to return a a value if the cell is Bud Light and only ...
1
vote
1answer
189 views

Filter the row containing an exact word and highest value in Google Sheets

I have a table (Master sheet) in Google Sheets that looks something like this: https://ethercalc.org/t8f0ze0kyx6a I need to filter out an entire row of information on a separate sheet (Last Lesson) ...
0
votes
2answers
333 views

How do I "bin" results in Google Sheets?

I am trying to bin my results so my groupings have lower granularity - going from a 1-10 scale to a 1-5 scale. For example, any result 1 or 2 would be renamed to 1 in the next column, any result 3 or ...