-
Creating lookups through control center
Hello, I believe there is a way to do what I am asking but I am just unsure how to accomplish this task. Currently in control center we have a "revenue template" and some of the data that needs to be in this sheet has to be exported from Power BI and currently we are coping and pasting the data into the revenue template…
-
Lookup Formula Not working
I am attempting to do a lookup of a a Date (on the Deliverable Tracker, shown in screenshot #1). The lookup will use the Effective Start and End dates to find the appropriate range, then the end result will be the text value column at the far right. My formula shows a blank result, here is the formula:…
-
Cross-Referencing Another Sheet for Matching and Looking Up Values
Hi! In my first sheet, I have a column "Date Submitted to Courseware". Then, someone selects an "Analysis Priority". First sheet The Analysis Priority should look up the References sheet to the columns for AnalysisPriorityTypeDropDown, match that, and figure in the AnalysisPriorityTypeValue number of days, and figure in…
-
DataTable - Lookup Mode with multiple values
I am attempting to use DataTable to pull compliance information into a sheet. The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot…
-
Index/Match formula using a range of values?
Hello, I'd like to create a formula or series of formulas to accomplish the following… There are two sheets: Source Sheet Return Sheet Source Sheet: https://us.v-cdn.net/6031209/uploads/RY816MEYP46R/example-source-sheet.xlsx Return Sheet: https://us.v-cdn.net/6031209/uploads/ZG5YB9OMWQK4/example-return-sheet.xlsx What I'd…
-
[Need Help] Lookup/Index matching for Horizontal Data
I’m trying to automatically assign a reviewer type (like “Peer” or “Leader”) based on a reviewer’s phone number. The problem is that in my reference sheet, the 20 possible reviewers are listed across columns — each one has a phone number and a reviewer type in a separate column. In my submission sheet, I just have one…
-
How do I use Cell reference in a formula when using Index?
I have a simple table that has the following columns (along with other columns), ZZZ YYY 10 15 and I would like to replace the ZZZ and YYY in the following formula =INDEX([Thing1]ZZZ:[Thing2]YYY, 1, 1) With the data from the columns above so that the resulting formula would be: =INDEX([Thing1]10:[Thing2]15, 1, 1)
-
Datatable Lookup Mode: Checkbox if no Unique Identifier Value was found in the Datatable
I'm using a Datatable Lookup to populate rows on a sheet. Is there any way to add a checkbox automatically if the system found no result of the Unique Identifier in the datatable? To be clear, I mean the value in that Row's "Sheet Unique Identifier" column was not found, and NOT that it found it but the mapped columns…
-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…
-
Datatable Lookup Feature Request: Don't Overwrite Existing Data / Skip Blanks
I wish to be able to tell Datatable Lookup Mode to SKIP updating cells that already have values in them, especially if the datatable lookup value is blank. In a "Lookup Mode" Datatable connection, when mapping Datatable fields, it would be very helpful if there were an additional column with a checkbox labeled "Update…