Questions tagged [lookup]
The lookup tag has no usage guidance.
128
questions
0
votes
1
answer
26
views
How to lookup values from dropdown lists in Excel?
I have a complicated Excel worksheet, but I will simplify what I need in a simple scenario.
I have the following sheet as raw data.
Also, I have another sheet where I can select the student's name ...
- 5
0
votes
1
answer
41
views
How two-way lookup works in excel?
The two-way table is a table where the value of a dependent variable is dependent on two independent variables, so actually it's a mix of two one-way tables.
When you lookup for a value in a two-way ...
user1806663
1
vote
1
answer
47
views
xLookup with two variables
Thanks in advance for your help here. Scenario: I have customers that purchase "credits" in agreed multiples of x, and I need to report when these packs have been depleted.
I'm mining the ...
- 11
0
votes
2
answers
24
views
Find Multiple hits of the search value across all columns & rows of a table and return a list of the results from the 1st column of the table
I have a spreadsheet that holds a list of offices in the 1st column. Each column after this holds the list of Postcodes that this office covers (only the 1st part, ie se3). Some of the postcodes are ...
1
vote
0
answers
55
views
Excel: Icon conditional formatting based on column name lookup
I am trying to create a conditional formatting rule for a table which looks up a pass mark in another table and then compares the value to that pass mark. It is meant to be as general as possible ...
- 157
0
votes
1
answer
50
views
Excel find non matches reverse XMATCH
I need a formula that finds non-matching entries in array1 with the criteria array2
To make this simple (and as the actual data is confidential)
array1 is {"a";"b";"c";&...
- 53
0
votes
2
answers
80
views
Why does this LOOKUP function work like this?
Can you please help me understand why this LOOKUP function works as it does? The formula in yellow-highlighted cell A6 seems to return the label (from row 2) above the rightmost non-zero data value (...
4
votes
4
answers
326
views
Lookup over matrix with non-numerical data
I have several minitables (title, content) organized in a matrix, like the following example:
I want to do a lookup such that I put the "title" value in a cell, and return the content. So, ...
- 159
0
votes
3
answers
580
views
LOOKUP Column Value based on right-most value
I have a list of footage for a film that is continually changing. They are organized in rows by REELS, and the rightmost value will be the latest version. The first row are dates and the rest are ...
0
votes
2
answers
1k
views
#NAME? Excel error only occurring on one computer
We are using Excel 365. I was teaching my colleague XLOOKUP yesterday but she kept getting #NAME?.
What she entered was correct. She redid it in a new column in case any odd formatting was causing ...
- 23
0
votes
1
answer
64
views
HOW TO SUBTRACT LAST ENTERANCE WITH PREVIOUS ONE
I need help, I have been trying for hours to figure this out.
I need to keep track of material consumption and report it weekly so I need to subtract previous value of some material from current one.
...
0
votes
1
answer
50
views
How to use COUNTIF with two conditions
I am attempting to count how many rows resulted in the following:
Have a "Successful" launch status
Have a list size that surpasses the circled area in R10
I know how to simply find which ...
- 39
2
votes
1
answer
2k
views
How to add my own mapping table to the dropdown menu of the "field lookup" function in the "Transform" tab of a Grafana dashboard panel?
The following functions are from the "Transform tab" in Grafana, have a look at Transformation types and options for examples.
I have tested the "Rename by regex" function which ...
- 1,891
1
vote
1
answer
74
views
Need to lookup values in row and give the corresponding month in the column
I need a formula that looks up the number of sales in a month and stage and gives you the highlighted cells in the columns. It has to count the first cell that the sales start in and then if you have ...
- 11
0
votes
1
answer
175
views
VLOOKUP and HLOOKUP combo
I am struggling with the following (see snapshot) and I can't understand what I'm missing.
If the id matches, I would like to extract the value of that id in when the values in col2 matches the ...
- 101
0
votes
3
answers
1k
views
excel formula to look at only 10 digits of the cells
I want to look at only the first 10 digits of the cells.
If the cells that are in column C equals to the cells in column G (but in another tab), then I want the result from column H(from same tab of G)...
- 5
1
vote
2
answers
85
views
How to find the value of Column A on the first instance of Column B > Column C
Given the below table
I have Column A as a unique key value, I am looking to return the first key value where B < C
In this case the first instance is A = 3 Where B = 4 and C = 5
Can someone help ...
- 121
0
votes
0
answers
64
views
How can I merge multiple individual worksheets in an Excel workbook that are in the same format (but different lengths)?
I have an inherited (and sometimes still-updated) workbook with many worksheets (currently 50+).
Each of these tabs has a table in the format of:
segment_name | subsegment | subnet | ipaddress
^^...
- 9,930
2
votes
0
answers
17
views
Chain DNS lookups for "not found" answer/events
Im trying to chain multiple dns server.
I want that my local dns server is asked first, if no entry was found a second and third should be asked.
Is this possible?
My /etc/resolve.conf looks like this:...
- 265
0
votes
1
answer
2k
views
How to return first non-blank value with LOOKUP function
I have a table:
table in which I reference data from a dataset using a LOOKUP function. I can reference columns(such as new_deaths) which have the latest(non-blank) data just fine. However, for some ...
- 5
0
votes
1
answer
97
views
Excel lookup returning multiple values in a column
Everyone -
I have seen numerous posts on this site similar to this, however with the way the data is laid out, none will work for what we are trying to accomplish.
I have a spreadsheet with columns ...
0
votes
1
answer
37
views
Look for Date values in embedded in strings
I have a value in a cell that might have a 2-digit month and 2-digit year value embedded in it, and I need a function that would return TRUE if that is found.
Sample input data: sCa!1220LB6qHZbCnsEE ...
- 307
0
votes
1
answer
84
views
How to get the last value of a column that is not blank and match it with a cell in a Google Sheet?
For example, the value of the cell is David. Column A has the names of students. Column B has the dates. I need to get the last date if I enter the name of a student.
I was trying to use the LOOKUP ...
0
votes
0
answers
608
views
Memory Exception on Excel Fuzzy Lookup Add In
I have two tables of data with 5 columns - Name, Phone Number, Email Address, Post Code and Order Time. Both tables have around 10,000 rows. I need there to be an exact match on Name, Phone Number, ...
1
vote
1
answer
84
views
Excel lookup by minimum value
I have this table:
.
Is it possible to look up the letter grade by the minimum percent value?
For example, anything greater than or equal to 87% but less than 90% returns B+.
- 113
1
vote
1
answer
73
views
Excel - How do I look up multiple cells from a single reference?
I'm looking to somehow look up a certain amount of cells from a single reference and return them in the same order in another workbook.
For example, say I have 5 different SKU codes (these aren't ...
- 11
0
votes
1
answer
312
views
Finding a Row Number based upon a value within a known column?
I have a workbook that's set out in a fairly specific way when imported. And I'm one lookup away from having them quickly and easily sort itself out into a more readable form.
However, without using ...
- 1
0
votes
1
answer
252
views
Take the header of most-left value in excel
I'm using the formula from this post to take the most left value from my excel sheet.
I’m using this formula for column “N” as shown at this excel print screen.
Now I have to find the most left value,...
1
vote
1
answer
104
views
Dynamic Array lookup
The values in E should match the values in D but don't. Am I using lookup wrong?
This is just a test from a larger problem I'm having. I decided to make a testbed to figure out how to use LOOKUP. My ...
0
votes
1
answer
83
views
Match 5 closest in same array
I have a list of customers and lat/long coordinates (3 columns:c,u,v respectively) I want to create 5 columns to resolve as the closest 5 customers.
So far I’m using
min(sqrt(([lat1]-[lat_array])^2+...
-1
votes
1
answer
21
views
Too many arguments in use if and lookup functions
I am using an IF formula with LOOKUP in order to evaluate and return a value in a table. For example, to return a value in a salary matrix,
=IF(K5>10,G5+SMI!$G$25,IF(I5=1,LOOKUP(K5,SMI!$F$10:SMI!$...
- 11
2
votes
2
answers
174
views
Lookup Range based on multiple column and row critera
I have the lookup table below, where columns C through E are different places:
Below, I am trying to lookup the value based on the columnar and row criteria:
How can I find the value Orange, 2019, ...
- 21
1
vote
0
answers
35
views
How to search for and return all records between two dates?
I'm not sure if this is a lookup formula I need. Basically, I have a huge spreadsheet with the travel details of lots and lots of groups. Each row is a different group. For reference, Column K shows ...
- 11
0
votes
2
answers
692
views
Using AVERAGEIF() over a range of years
I have a dataset that includes year, country, and population data. A small condensed sample is below.
I am trying to write an excel statement that would calculate the average population from 1980 - ...
1
vote
1
answer
87
views
Excel: Use Cell in Formula Based On Criteria
I have the following Excel workbook sheets.
SHEET 1 contains data on criminal sentences handed down for specific individuals:
| Name | DateOfBirth | DateOfSentence | SentenceYears |
|------|---------...
- 113
0
votes
1
answer
1k
views
Calculate weighted scores via column heading lookup in Excel
I have a data entry sheet with multiple columns, and the user is allowed to input a number in each cell.
I have a separate table with a weighting based on each Column's heading.
The desired output I ...
0
votes
2
answers
44
views
LOOKUP reference with mulitple outcome values
I am looking to pull out and display the multiple ages of people associated with a single reference number.
Below snipped displays the sheet set up. The sheet has approximate 2500 rows:
App ref,...
- 1
0
votes
1
answer
42
views
Assitance with Lookup function for matching two sheets of data
Basically I have two sheets (s1 and s2), and the data is formatted something like below, first is S1:
ID Name
1 Prod 1
2 Prod 2
3 Prod 3
4 Prod 4
5 Prod 5
6 Prod 6
...
- 3
0
votes
2
answers
552
views
Exclude IPs from IP list that are from Russia
Which command in Bash should I use to exclude all IPs that are from Russia from an IP list?
I had in mind maybe with the help of geoiplookup. What I would really like to have as result;
original-IP-...
- 21
1
vote
0
answers
1k
views
Microsoft Excel Fuzzy Lookup add-on - set too big?
The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...
- 11
1
vote
1
answer
52
views
Values in a column to rows based on multiple criteria
I am trying to turn a the table on the left side to the one on the right.
How can it be achieved? I have tried This, but it did not work.
- 113
0
votes
1
answer
92
views
Row data distributed into multiple rows on a separate sheet
I have a fuel consumption log, with vehicle id's in column 'C' and fuel consumed and distance traveled for different dates as the headers.
example
I have made multiple sheets based on the vehicle id'...
- 11
0
votes
0
answers
211
views
Excel HLOOKUP to reference multiple Cells as "lookup_value"
In this file:
https://drive.google.com/open?id=1rwPyt7RKLCVIMWEuAxdl3H3vYxXtUX8S
Cell A3 on the first sheet "Import Template" has this formula:
=IFERROR(IF(HLOOKUP(A$2,Sheet1!$A:$ZZ,ROW(A2),FALSE)="...
- 113
0
votes
2
answers
3k
views
Map/Copy values from one sheet to another in excel if they match on column header
This post gets me very very close to where I need to be
How can I copy a column from one sheet to another sheet based on title in Excel?
However if I add an =if(isblank(Sheet1!A2),"",... to the ...
- 113
1
vote
1
answer
64
views
Returning the column header when the progressive difference of values in a row becomes <= 0
I have an Excel table with the initial stock for an item and the projected consumption based on the corresponding dates in the header. I would like to retrieve the date when there is going to be a ...
0
votes
1
answer
136
views
How to lookup for NA value in Excel?
I have two sheets:
Contains form number and amount
Contains bill number and amount
I tried to reconcile which bill belongs to which form using simple lookup based on the amount, ignoring duplicate ...
- 1,716
1
vote
0
answers
66
views
MAX Result of multpiple results from INDEX and MATCH
I am working with 3 columns, fname, lname, & date. Where there will be multiple duplicates of fname and lname. I am trying to write an INDEX & MATCH that will display the MAX result or the ...
- 11
2
votes
2
answers
10k
views
Finding the next higher value in a column
I have two columns, A and B. Column B has values which I need to look up in Column A. However, I don't need to find the exact corresponding value, I need the next higher value.
For example:
Column A ...
0
votes
2
answers
627
views
Lookup Function Giving Inconsistent Results in Excel & Google Spreadsheet
I am trying to create a column of looked-up values using the LOOKUP function. The goal is for the formula to look up the "rank" value of each "name" and print it in the "lookup" cell on the same row.
...
- 115
1
vote
1
answer
169
views
Allow a cell containing multiple delimited lookup source values to also contain non-lookup values
Lookup multiple values in a different table given a cell containing multiple delimited values
Please open the link to see the previously answered question.
Given that context, is there a formula ...
- 25