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’).
188
questions
0
votes
1
answer
32
views
How do I put the if function inside the lookup? - Daily Routine sheet
I have a sheet - daily routine which has two columns: activity and time as shown here
Activity
Time
Sleep 😴
6:00 am
Toilet 🚽
6:15 am
Get ready for gym 🤸♂️
6:30 am
Exercise 💪
7:50 am
... ...
- 101
0
votes
0
answers
16
views
How to approach this? Which formula should I use?
I am working on a Google Sheet in which I am classifying a "product" with an id number and I want to pull out data from another sheet that contains 2 things:
confirmation of the id
type of ...
0
votes
1
answer
10
views
Extending a formula (VLOOKUP) to the whole column
I created a VLOOKUP formula inside a Google Sheet, I have 130000 lines and need to extend the formula to the end of the column.
- 1
0
votes
0
answers
24
views
Multivariable Matching in Google Sheets - scanning for multiple values simultaneously and posting shared data
I have two sheets from two different sources (Facebook Ads and Google Ads) and I want to match their data onto a third sheet. The data itself is different, but the identifiers are the same - campaign ...
vdog
0
votes
0
answers
14
views
"OutputSheet": function on edit: lookup value in "LookUpSheet" and change OutputSheet.value
I have a sheet with a column that contains a dropdown.
The options in that dropdown are readible strings (idiot proof)
But for further processing, these strings need to be converted to numbers.
So on ...
-1
votes
1
answer
24
views
Fantasy Football league stat tracker
I am the commissioner of a small tabletop football league in Southern California. I'm currently using a league template spreadsheet to track individual player stats (TDs, passes, etc.), match results, ...
0
votes
0
answers
54
views
Google Sheets - VLookup and date
My problem is that I am unable to return a value based on a specific date (eg "01/28/2022") within a Google Sheet using VLookup. I have searched the site and cant find a solution.
I have 2 ...
- 1
0
votes
0
answers
26
views
Multiple IF statements and VLOOKUP in Google Sheets
I have a IF statement VLOOKUP statement working, this took me a while but it is as follows
=IF(AX16="A091";(VLOOKUP(AZ16;Tables!$A$297:$B$309;2;FALSE)))
Basically if AX16="A091" ...
0
votes
2
answers
25
views
Using the contents of a cell to act as a range in VLOOKUP
I AM USING GOOGLE SHEETS, NOT SURE IF THIS IS THE BEST PLACE TO POST BUT FOR CLARIFICATION!
Hi there, I am attempting to index the contents of a cell and use that as the range in my VLOOKUP formula.
...
- 1
0
votes
1
answer
21
views
Reorganize csv data
I work in a school that has multiple data entry forms and formats and I am trying to find a way to automate one example of data duplication.
We put student report card grades in on one online system, ...
0
votes
0
answers
36
views
Using a vlookup to pull from a table of a team min and max values for specific stats
So I am working on creating a stat sheet and learning a lot as I go along and using a lot of different tutorials and videos to learn how to write my own formulas, but I seem to be stuck on this one. ...
0
votes
0
answers
23
views
Generate a number based on two drop down list selections
I'm trying to create a pricing calculator for my handmade business. I've gotten really far and have all my products separated out on different sheets based on material type, then have those sheets ...
0
votes
1
answer
36
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
2
answers
50
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
2
answers
288
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, ...
- 9
0
votes
1
answer
43
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)....
- 15
0
votes
0
answers
53
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 (...
- 3
1
vote
2
answers
59
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 ...
- 13
0
votes
0
answers
10
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
1
answer
404
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 ...
- 195
0
votes
1
answer
60
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
0
answers
9
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
1
answer
145
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
1
answer
51
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
1
answer
79
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 ...
- 3
1
vote
1
answer
152
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 ...
- 13
0
votes
1
answer
29
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 ...
- 1
1
vote
0
answers
30
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 ...
- 11
0
votes
1
answer
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 ...
- 145
2
votes
1
answer
63
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 ...
- 371
0
votes
1
answer
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 ...
- 135
0
votes
1
answer
89
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
2
answers
940
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 ...
- 151
1
vote
1
answer
114
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 |...
- 145
0
votes
1
answer
45
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
1
vote
1
answer
631
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 ...
- 35
0
votes
0
answers
25
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 ...
adminsneedhelp2
0
votes
1
answer
44
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 ...
- 3
1
vote
1
answer
43
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" ...
- 13
2
votes
1
answer
288
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 ...
- 57
1
vote
1
answer
71
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 = ...
- 57
1
vote
1
answer
503
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 ...
- 11
1
vote
2
answers
449
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
1
answer
36
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
2
answers
723
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
1
answer
56
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=...
- 11
1
vote
1
answer
484
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 ...
- 479
2
votes
1
answer
85
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:
+-----------------+-----...
- 35
2
votes
2
answers
14k
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 ...
- 608
1
vote
1
answer
1k
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 (...
- 11