3,727 questions
Advice
0
votes
1
replies
31
views
Multiple criteria formula to include horizontal and vertical lookup
I am trying to write a formula that has multiple conditions looking up both horizontally and vertically.
In the Excel table below, col's A to G are the data.
Col's I to L needs to be the combined ...
- 1
0
votes
1
answer
155
views
How to give a hint to std::map::lower_bound?
I want to give hints to std::map::lower_bound.
Why isn't it even allowed?
Suppose we need to implement something like:
static constexpr int TOTAL_SIZE = 1'000'000;
std::map<int, std::string> map{...
- 21
0
votes
1
answer
66
views
Use a setting value from one MongoDB collection in a lookup referece in another collection aggregration
Lets' say I have a collection called settings, that has a document where the _name field has a value of A and in there there is a data.year value i.e.
"settings" : [
{
_id: ObjectId('...
- 83
3
votes
3
answers
187
views
Excel formula doesn't match Excel cell
I have a game log that contains a running ELO score. I am attempting to search through this game log to retrieve the most recent ELO recorded for each player. I believe I have managed to do this ...
- 5,050
0
votes
1
answer
129
views
Power Apps lookup help, code works in dev but not published
I'm building a canvas app that uses a lookup to set the value of a variable. That variable then determines whether a modal is shown to the user or not.
If the lookup finds a record matching the ...
- 115
0
votes
1
answer
49
views
Configuring external user-defined module for multiple scripts in python
I am running several python scripts (one at a time) to manipulate photo, video, and audio files in different combinations in the CWD.
Instead of specifying in each script's body the dozens of "...
- 727
0
votes
1
answer
25
views
In C, how do I use a single hex value in both an enum and a const char *
I have a function that allows access to system variables based on a lookup code. The lookup code has an enum type.
typedef enum SystemVariable_e {
INT_SYSTEM_VAR_1 = 0x10,
INT_SYSTEM_VAR_2 = 0x20
...
0
votes
1
answer
117
views
Getting Splunk's Lookups' scheme in a single query
I want to create a query to fetch all the lookups that I have in my Splunk system (or even a predefined list) and their full scheme.
It should include the headers and the types for each column.
I ...
- 121
0
votes
1
answer
69
views
Microsoft PowerApps Table Lookup - Navigating to Different Screens Based on User Type
I'm having trouble getting this login page to work. It needs to take the user to a specific page depending on their credentials. There are 3 different tables for the different types of users.
This is ...
- 1
0
votes
1
answer
100
views
How to change the font color or highlight a string in between to asterisks in python?
My df has 19 columns but for simplicity the df will have the following columns [['Gene_name','Genes_in_same_transcription_unit']]
The column 'Gene_name' list a bunch of genes in E. coli and the ...
0
votes
2
answers
59
views
Change the lookup column every month based on Updated Forex actuals
Attached is the excel file with Sheet1 from column A to C. My objective is to calculate the inventory Value form C4 to C8 on monthly basis, based on updated foreign exchange currency (Sheet 2 - F to J)...
0
votes
2
answers
78
views
Return nth value in multi criteria vlookup
https://docs.google.com/spreadsheets/d/1jb9dKFAEL2IWP5C1z5S3cEKol27vYqcsISh1l16KlLQ/edit?usp=sharing
I have created the above Google sheet where I am doing a Vlookup in col. A to return Vlookup value ...
1
vote
0
answers
36
views
Is there a way in Tableau to go through a series of numbers in a field (delimited by ",") then do a lookup for each from another data source?
I have a series of IDs in a Tableau column that I need to derive the actual names from another data source (like a vlookup or join via the ID), and display the actual names on a new Tableau field. See ...
- 31
5
votes
1
answer
110
views
Most performant approach to find closest match from unordered collection
I'm wondering what the best approach for finding the closest match to a given value from a collection of items is. The most important part is the lookup time relative to the input size, the data can ...
- 346
-2
votes
1
answer
118
views
How to lookup multiple values at once in a table and return a single column [closed]
I have a table that lists car brands (Ford, GM, Toyota, etc) and their corresponding models that we have in inventory. See link below.
I can use Query to pull up all models from a given Brand (say, ...
- 1
2
votes
0
answers
188
views
In C, is there any advantage to using a lookup table over a case/switch statement? [closed]
For decades, I have used a C program to do keystroke mapping in Windows. I decided to try Microsoft's Copilot in case it would give me any speedup ideas. (My program only re-maps keys if the <...
- 665
0
votes
2
answers
99
views
Unable to write lookup output to Pandas dataframe using append loop [duplicate]
I want to lookup column in dataframe (Lookup item) using pandas (or anything else). If the value is found in that column then corresponding value in another column (Corresponding item) of same ...
- 115
0
votes
1
answer
157
views
How do I view lookup table values with Blazor QuickGrid?
OK I'm playing around with a Blazor tutorial and I'm experimenting with lookup tables - a Movie table and a MovieStarRatingTable.
This is my Index Page:
@page "/movies"
@rendermode ...
- 21
0
votes
1
answer
328
views
How to Filter SharePoint Lookup Column
I want to use a secondary list to populate a dropdown column in my Sharepoint list. However, the secondary list contains data I don't want to have pulled over based on the type column.
Imagine tables ...
0
votes
0
answers
129
views
SAP SF Employee Central get text values for external codes
How do I get SAP SF Employee Central texts for codes?
In our project we read data from SAP SF (Success Factors) Employee Central via ODATA. We read the ODATA API Objects via f"https://{...
- 14.6k
0
votes
1
answer
54
views
MongoDB lookup on two field with condition of third field (array)
I have these two MongoDB collections:
Collection A
{ "_id": 1, "field1": "A", "field2": "", "value": 42 }
{ "_id": 2, "field1&...
- 185
0
votes
2
answers
88
views
Matching contents of a cell to comma-separated values in another cell
I have a category list as shown below; PAYEE contains comma-separated values for each cell value in EXPENSE CATEGORIES:
How can I use VLOOKUP or XLOOKUP to match the values in Merchant Name to PAYEE ...
- 53
0
votes
1
answer
68
views
How to I get excel to look up values in the nth column based on a number in a cell?
I'm trying to make an inventory spreadsheet that calculates a bunch of metrics, all based on summing amounts of stock across multiple sites. I was using:
=XLOOKUP(
[@[Product name]],
Ontario!$B:$...
1
vote
1
answer
749
views
Power App - How to use text value for Column Name in Formula?
I am creating an application that requires showing unique records based off of the current user's department. I have two tables, one that has records to be reviewed and the other that has team members ...
0
votes
0
answers
34
views
Inaccurate Cube Data Interpolation Result
I have 1,000 points of grid (equally spaced) measurement data that consists of input/stimulus (triplet) and output/result (triplet).
This data is populated in a 10x10x10x3 data structure, basically a ...
- 1
0
votes
1
answer
89
views
Lookup matching cell in a table and return the value of the first cell that's merged upwards to the matching cell
Good day,
I have a spreadsheet with a manually populated table (B:D).
Then, I'm attempting to create an extract from that table based on the values from column B according to the value from cell I2. ...
- 57
0
votes
1
answer
127
views
How to add new sections of a formula for each new input in excel?
I am making a grid map that you can place specific source points into based on coordinates and I would like the formulas to automatically update for a much higher number of sources. If a cell is not a ...
- 13
0
votes
2
answers
141
views
How to return the column and row headers for a lookup value?
I am trying to return the column and row headers for the different locations in an array. In this case the X and Y coordinates of S1 (2,2), S2 (9,3), and S3 (2,9). I have tried using the following ...
- 13
1
vote
1
answer
216
views
Regex matching in a Splunk search query that involves a lookup table
I have created a lookup table in Splunk that contains a column with various regex patterns intended to match file paths. My goal is to use this lookup table within a search query to identify events ...
- 21
0
votes
1
answer
46
views
Elastic query that harvests all indexes with a field that has a specific data type
I am getting mapping conflicts in elastic. The field in question needs to be a float, however its getting mapped as a keyword.
I need a query that can harvest all indexes that have this field. I want ...
- 1,328
0
votes
1
answer
84
views
Excel return sum of variable date in row where criteria is met
I need to find a date in a row 3:3, and then add all the amounts in that column where in a different column A:A the text is = to a specific criteria
Criteria
1/1
1/2
1/3
Bob
1
4
2
Sue
3
1
3
Jill
1
1
1
...
0
votes
0
answers
48
views
Drop susbsequent records after a join where sequence number is greater than one sides join values [duplicate]
I have 2 dataframes, one with records of fallers (entered by office admin) in a given race and , the other serves as a lookup for identifying where a fall happened so obstacles encountered in a given ...
- 173
0
votes
0
answers
59
views
Values aren't matching a list (python)
I am trying to have a user type in a hostname and if it matches then return other items in the list
I was able to append it to new list if item is online but I can't seem to return a match if they ...
0
votes
1
answer
51
views
Google Sheets - select "most recent " cell in a column and return corresponding value in same row
I'm working on a tracking spreadsheet for stock trading and want to create a "current profit/loss" cell that needs to search for the most recent "type" of trade and return a ...
- 3
-1
votes
3
answers
84
views
Use a mapping function to map one property to another object
I have an array of objects as per below.
songs = [
{
track_name: "name of track" ,
track_genres: ["chamber pop","indie pop"] },
{
track_name: "...
- 3
1
vote
0
answers
171
views
using $geoWithin in a Mongo $lookup aggregation
Trying spatial lookup with Mongo, I've got 2 Collections.
The first "addresses" contains simple addresses locations :
{
"id_addr" : "id1",
"location" : {...
- 71
-2
votes
2
answers
171
views
How do I lookup row labels, find a value in an array on that line, and report that specific column header?
enter image description here
See image of my simple table in excel for reference
I have a sporting event that a person is assigned a division: Which is the value in H3.
Lookup this division in the ...
- 3
1
vote
1
answer
46
views
How to lookup item value and sort by header name and value from small to largest
I am stuck at this problem. Been looking everywhere in Google using several phrases but no luck (or maybe I am just super confused at the moment).
I am looking for an excel formula where it can sort ...
- 11
0
votes
1
answer
430
views
ADF Lookup Activity sometimes not returning value after changing to the new SnowflakeV2 linked service
I have the following lookup activity in ADF pipeline where it is using the new SnowflakeV2 linked service. However, sometimes it does not return any value even though the query is correct. I have ...
- 1
1
vote
0
answers
46
views
Project query in Springboot didn't work well
In SpringBoot Applicaton,when i query mongo like this in MongoRepository:
@Aggregation({
"{$match:{createUid: ?0}}",
"{$lookup: {from: 't_user',localField: '...
- 11
0
votes
2
answers
105
views
VBA for Index match lookup to return multiple columns by Column name.but column name is not the first column for the lookup
I have a complex situation where I could not find answer in any forums so I'm posting this as a new question.
Basically this is a Lookup script from Sheet"Data" to my Search sheet which is ...
0
votes
1
answer
73
views
Using dataset column values Lookup artifact in a foreach artifact
I'm trying to use a dataset result from a ADF lookup artifact in a foreach. I need to use each column of the result in a query within the FOREACH artifact.
The lookup is linked to the FOREACH and the ...
user7395346
-3
votes
2
answers
81
views
Formula to find the nearest match
I need a formula to cell G2 to find the nearest match based on cell E2 and F2.
My desired result would be Working Offline, since range A2:A13 = E2 (Agent 1) and C2:C13 = F2 (10:00:00), the status ...
- 137
0
votes
0
answers
100
views
PowerApp Lookup Original Value on Edit
I have a PowerApps SharePoint form that uses cascading lookups.
They work perfectly when creating new records, but whenever editing, the fields always start as blank, which means the user has to ...
- 1,381
1
vote
1
answer
86
views
Finding a value in an Excel array
I have to imagine the answer is somewhere but I am not sure where.
Here is the situation: I have a 6-column array of numbers starting from zero, and they increment sequentially, but not in every cell,...
0
votes
2
answers
491
views
Excel Parent Child Relationship and Part Level
Any help is appreciated on this issue. I originally came here to get help on this and was able to find a solution that has worked up until now.
To reference the original post here is the link:
Excel ...
1
vote
1
answer
57
views
MongoDB Aggregate - $lookup pipeline query from array of objects in document and match to a separate collection document's array of objects list
Playground link:
MONGO PLAYGROUND
I would like to end up with the following query result.
One card that matches the beginning match where filters, which starts as an array of strings and ends up with ...
- 16k
0
votes
1
answer
118
views
ADF Pipeline Scheduled Hourly Fails Occasionally with Lookup Activity Fetching Last Ingested Date from Databricks Catalog
We have scheduled an ADF (Azure Data Factory) pipeline that contains a Lookup activity, which is responsible for fetching the last ingested date from the Databricks catalog(Hive metastore). This ...
- 25
3
votes
2
answers
52
views
R: Replicating an INDEX MATCH to the Corresponding Column
The operation I want to achieve is similar to an Excel-style INDEX MATCH. Essentially, I have a frame:
dta <- read_excel('CPI/Global Inflation New.xlsm',
sheet = 'Cleaned', skip = ...
- 269
0
votes
1
answer
118
views
Adding Subform fields to approval summary in zoho creator
I am creating an e-procurement application on zoho creator.When a material request is submitted.It should be directed to manager for approval. In the approval summary, I am not able to see the product ...
