Questions tagged [lookup]
Look up is related to indexes and hash tables. It is the action of accessing fastly to an item in a large collection thanks to a index (a so-called lookup table).
lookup
3,682
questions
-2
votes
0
answers
34
views
Excel - How to create a dynamic lookup function that pulls data from the right most column as columns are added [closed]
I am currently working on a project where I import data from a specific worksheet daily, in which the data is automatically inputted to the column next to the previous data (i.e. Day 1 - Column A, Day ...
0
votes
0
answers
21
views
Python Pandas: Select matching value from other table with comparison into each row without matching key [duplicate]
I have a structure of events happening for entities in table A.
Each event is linked to a process in table B.
Unfortunately I don't have the process ID in table A only a timestamp. Table B includes ...
0
votes
2
answers
29
views
Google Sheets Vertical Lookup in Conjuction with Summation
Creating a tip-tracking spreadsheet. Using Google Sheets.
In the workbook, I have one sheet (Data) where a name may appear multiple times. I have another sheet (Summary) that is exported. The Summary ...
-3
votes
1
answer
43
views
Show Table From Drop Down List
Can you look up and show two columns or a table based on a cell's value?
I want to select either group 1 or 2 or 3 from the dropdown in B1. No problem creating the dropdown.
What formula/s should I ...
2
votes
3
answers
61
views
How to find the weeknumber related to the latest value in a workload matrix?
I've created a workload chart that assigns production hours to projects for every production department. For a single production department, this looks like this:
Workload for a single department
...
0
votes
1
answer
60
views
How do I find a result in an adjacent cell when there is a mix of letters, formatting, and numbers?
I don't want to go too far into this project before getting my fundamental problem fixed.
When I put in =LOOKUP(120/7C/ME,A2:A6,B2:B6).
I get We're Working It when I should be getting Cargo Chargers. ...
-1
votes
1
answer
24
views
Trying to return forecast values by date and by time using export from a different system
I have an forecast that is exported from our scheduling system that has times on the left and dates at the top with the forecasted numbers under those dates. I'd like to have a formula/search that ...
0
votes
0
answers
12
views
Grafana loki queries lookup
New to Loki Grafana and coming from splunk back ground.Like how we have lookups in splunk what is equivalent that in Grafana loki.
My uses case is, in my logs I have 100's of codes and which doesn't ...
1
vote
2
answers
39
views
Merge on one column if condition met else merge on another column
So consider these dfs:
data1 = [{'name': 'Muhammad', 'age_x': 20, 'city_x': 'Karachi', 'number' : 1001},
{'name': 'Ali', 'age_x': 19, 'city_x': 'Lahore', 'number' : 1002},
{'name': '...
1
vote
2
answers
50
views
MongoDB find data between multiple related collections
I have 3 collections :
users
[
{ _id: 1, username: 'mark' },
{ _id: 2, username: 'leon' },
{ _id: 3, username: 'leontin'}
]
providers
[
{ _id: 1, name: 'prov1' },
{ _id: 2, name: '...
0
votes
1
answer
22
views
How to lookup Grades corresponding to Marks scored by students from a Grade-Slab table in Power BI?
This is the raw data table that contains marks against the subjects for each students.
There is another table 'Grade_slab' that contains details regarding the marks & grades from which I need to ...
0
votes
1
answer
26
views
MongoDB join collections foreign key
I have 2 collections with the following models:
User:
_id: ObjectID
name: string
org_id: string
Organization:
_id: ObjectID
name: string
I want to create a view that joins them like this:
UserView:
...
0
votes
0
answers
39
views
In PowerApps, Launch Attachments from LookUp SharePoint List
Launch Attachment from LookUp SharePoint List in PowerApp:
I have two SharePoint lists. The main list is called 'Methods' and has a LookUp Column 'Risk' and another column called 'AttachmentM' ...
0
votes
0
answers
11
views
formula that will return the Company Account number for the invoice number
In the screen shot provided the company account numbers are in column B, the invoice numbers are in Column D. I need a formula that will return the Company identifier when the Invoice number is ...
0
votes
2
answers
44
views
Get all dates when a certain activity is booked in google sheets
As you can see this sheet screenshot attached, I want to extract all the dates under which a certain name occurs. for eg. "srna" comes under 05.08,07,08 and 09.08 basically these are ...