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’).
50
questions with no upvoted or accepted answers
1
vote
2answers
43 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
43 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
2answers
772 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
81 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 ...
1
vote
0answers
68 views
Arrayformula with iferror and vlookup does not update automatically
My spreadsheet is for inventory checking. I use several of arrayformula ,iferror and vlookup.
The problem is I just noticed that sometimes the formula does not update. It might because I duplicated ...
1
vote
1answer
60 views
How can I change the formula of one cell based on the value in a different cell?
COLUMN D: Dropdown list of values
COLUMN E: IF function returning different values depending on COLUMN D contents
I have the functionality described above working properly. My problem is that I want ...
1
vote
1answer
2k views
Repeat formula n number of times in Google Sheets
Apologies, I'm very new to Google Sheets and spreadsheets in general. I'm trying to fill some cells with repeating data, and then analyze it. The data is pulled from another large spreadsheet and has ...
1
vote
1answer
29 views
How to get a cell's parent ID in Google Sheets?
I'm trying to bulk add a bunch of building product categories to my site's MySQL database. There are about 650 entries and about 4 levels in the hierarchy. For it to work, each entry needs an ID, and ...
1
vote
1answer
23 views
LOOKUP for data from other sheet
So I have a drop-down menu in order sheet and I have an info sheet. In the info sheet, I have 2 columns, column A has the customer name, column B has the customer e-mail.
So what I'd like to do is, ...
1
vote
1answer
1k views
Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE - use ARRAY or VLOOKUP?
I add/deleted/move rows frequently in my workbooks. When I add/remove rows from Spreadsheet#1 ("S1"), I need the referenced cell in Spreadsheet#2 ("S2") to dynamically update so it still references ...
1
vote
3answers
1k views
Copying data from one cell in another based on date
I have a spreadsheet, using google sheets, that I have formed into the following metrics:
Column A is the dates of the month
Column B is the data
I want to be able to copy the data from Column B ...
1
vote
2answers
68 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
18 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" ...
0
votes
0answers
9 views
Return all results for duplicate lookup values in google sheet
I have two tabs in Google Sheet.
Tab 1: Data, which contains all row data.
Tab 2: Output tab, where I need the results to appear.
The data is about products and their components. Each product has 5 ...
0
votes
0answers
18 views
Lookup whole column from one cell with multiple conditions, returns multiple matches separated with a comma for each search key
My data template:
My desired lookup table (no formula in B3:B, only in B2):
See this sheet for reference:
https://docs.google.com/spreadsheets/d/1TVU87H1fUDINQAhD5Cu5LXLuWW0GS4s6-FL274RVDz8/edit?...
0
votes
1answer
26 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 =...
0
votes
1answer
488 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 ...
0
votes
2answers
35 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 ...
0
votes
1answer
48 views
How do I add values from one sheet based on a dropdown that references the other?
I have 2 sheets with the same columns with integer values. In sheet A I have a drop down list of the names in sheet B. Based on what drop down I have selected, I'd like to add the values of sheet B to ...
0
votes
1answer
149 views
Having trouble outputting GOOGLEFINANCE data
My wish is to create a table in Google sheets looking something like this:
price
day A B C D ... Z
1997-01-02 132.54 . . . .
1997-01-...
0
votes
1answer
25 views
Assigning a value to a name from a list
I have items that I'm selling, and I've named these codes with the item I'm selling. I want to give these codes the price they should display. I've already got a formula to show the product of the ...
0
votes
1answer
53 views
Can I populate Google Sheets cells adjacent to a target cell?
I have a maintenance tracker in Google Sheets for lighting fixtures. One column is a type of fixture "B", the column adjacent is the problem "C". I'd like to find specific fixtures by name and copy ...
0
votes
1answer
43 views
Fetch value of a cell based on dropdown menu items results on another sheet
I have 2 Sheets named as Sheet1 and Sheet2...
Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column.
Sheet2: ...
0
votes
1answer
28 views
Having a formula output to a different cell
I have a Google Sheet in the following format:
ID | VAL
-------------
1 | dataH
2 | dataW
3 | dataX
4 | dataC
5 | dataG
6 | dataL
... | ...
ID and VAL are on cells A1 and B1, ...
0
votes
1answer
17 views
How do I search a string, and return all values?
How do I use the script editor to search a string in one cell, and return all results from another sheet?
For Example:
I have my string in cell B1 - which is the item number Data to be searched in a ...
0
votes
2answers
7 views
Look for a value that might be in many columns
Say I have a value in $A, to match to another sheet of the same file. That value (in this case, a student id) might appear in many columns of the other sheet.
In the following example, I am looking ...
0
votes
1answer
665 views
Auto-populate cells based on previous cell values in Google Sheets
I have two columns with information. Values in Column B have been manually added to match the values in Column A.
Is it possible to have a function that auto-populates column B with the right values ...
0
votes
1answer
45 views
How to use arrayformula to find and get data from only a certain, dynamic set of columns?
I have a table where my headers are dynamically generated from another source and can show up with any header values, in any order.
In the example below I've got the header values:
AA - BB - CC - ...
0
votes
1answer
63 views
Using a cell value, to dynamically create a formula, that links to a cell in a different sheet (tab)
Ok. This is a bit complicated, but I will do my best to describe the problem. All of these elements are located in multiple Sheet pages (Tabs) within one singular Google Sheet (Workbook).
Sheet 1: ...
0
votes
1answer
21 views
INDEX + MATCH to return the greatest of all matching values
I'm looking for the most recent date corresponding to a particular name. Dates are not necessarily ordered. I can't sort the target, I need it to work in any order.
Example: When was [Roberto]'s most ...
0
votes
1answer
24 views
Value transformation in Google Sheets
I'm working with a table of data as following:
User ID: Event name:
111 Event 1
222 Event 2
333 Event 3
111 Event 4
444 Event 5
111 ...
0
votes
1answer
21 views
Creating a formula based on TODAY's day
I have column A (list of stock prices at close of day)
A1=4/1/2019 | stock price
A2=4/2/2019 | stock price
A3=4/3/2019 | stock price
each day will be added to the sheet automatically
I want to take ...
0
votes
1answer
243 views
Linking a dynamic inventory price list to another file in Google Sheets
I've got a master inventory price sheet for all the ingredients we use in our recipes that I want to reference in all our recipe files to dynamically calculate costs. This way if we change suppliers ...
0
votes
2answers
86 views
Function to search columns and tally data
I am wondering if I can write a function to search a column in my spreadsheet for a specific name, then return x number of values within the row(s) that contain the name. For example...
M4 holds the ...
0
votes
0answers
19 views
Vlookup doesn't work at all
I am planning a birthday party now, and people have some options when it comes to what to eat.
I have a sheet with the options called ¨FOOD¨, then I have an overview sheet where I would like too what ...
0
votes
2answers
660 views
Match word in a cell with a column of words
I need to match a word to a list of words and then insert the category name in the cell next to it.
Eg. I will in Column A type a list of words like Apple, Red Apple, Coke, Carrot
The formula must ...
0
votes
1answer
160 views
How to use vlookup or indirect to copy data from another sheet, without changing the value on update of database
So I've set up automatic MySQL sheet that gets the data from it every day at 8pm.
I've set up everything with vlookup, and tried indirect. But I can't figure out how to make sure the values don't ...
0
votes
2answers
112 views
A formula for importing specific data into another sheet
I need a function for column K of Sheet1, that says:
"If the row of Sheet2 contains the same RID number as a row in Sheet1, then fill Sheet1 with the email address located in column K of Sheet2"
...
0
votes
2answers
426 views
Google Sheets Lookup For Nth Value
I am working on a spreadsheet that seeks to collate scores to a team. There is an input table where team and score start next to each other (see the example sheet linked below) into a table with each ...
0
votes
0answers
94 views
Pull data using a condition where there are multiple results in Google Sheets
My data includes multiple rows like the following:
Country | Company | Num of Activ. | Most recent? | Full URL | Init. Rank | Curr. Rank
Country A | Company 1 | 1 | Yes | ...
0
votes
0answers
1k views
How can I make a multiple criteria index,match array formula work?
I've been using array formulas in my google Sheets a lot, of the type:
={"Heading";arrayformula(if(len(A2:A)>0,FORMULA HERE,""))}
in order to "auto drag down" a formula when the A column is ...
0
votes
1answer
389 views
Lookup a value?
Is it possible to look up a value based on a value entered in a field - just like the VLOOKUP function in Excel?
0
votes
2answers
21 views
Query twice in the same cell to receive a name next to a number in a row
Sheet link
I posted before however, I don't think I was specific enough. I am sorry if I am wasting the time of anyone.
In my sheet, you will see three pages. On the "Search Notes" page in C5 I ...
0
votes
1answer
50 views
Look up a list embedded in a Google Sheets from a Google Forms, and add attributes to the corresponding row?
I'm running an event for a large number of children and need a way to let them register quickly as they come in, to the event.
We're expecting about 400 kids who have pre-enrolled and we will have a ...
0
votes
2answers
146 views
Replace value in field automatically (auto-correct?)
I'd like to replace occurrences found in Column A (cells A2:A200) so that if I enter 2/02/002 or 343 or 98/098 it auto-replaces it with UKD002/UKD343/UKD098.
Is this possible?
-1
votes
3answers
24 views
How do I sort data by size and not in ABC order
I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
-1
votes
2answers
48 views
Help with a Vlookup function to return multiple results of not exact match
I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are ...
-1
votes
1answer
29 views
How do I find latest invoice number & dates?
Trying to find a formula for the latest date and invoice number.
Here is my sheet:
https://docs.google.com/spreadsheets/d/1T_rFYDCQhqfrsU9claYPHQTrEz68zpUFKG9HZqqV4Z8/edit?usp=sharing
-1
votes
1answer
500 views
Vlookup in external spreadsheet
Is it possible to use VLOOKUP with an external spreadsheet?
SpreadsheetA contains a set of a few hundred addresses.
SpreadsheetB is an invoice.
I want to use VLOOKUP in the invoice to return ...
-1
votes
1answer
14 views
Sorting column A with drop-down and column B with checkbox
I have a spreadsheet that I use to run a foosball tournament, and in column A I have a dropdown data validation that will let me select a players name. In Column B I have a checkbox that I check once ...
