-
INDEX / MATCH / CONTAINS Assistance
Looking for your help, the below formula works for the moment: =IFERROR(INDEX({SFDC Opps for Renewals Range 1}, MATCH(SFOP@row , {SFDC Opps for Renewals Range 2}, 0)), "No Match Found") However the column above actually contains multiple SFOPs and so I think I need to add a CONTAIN element to the formula so when SFOP…
-
Cross-reference sheets to find matches
Hi! I am trying to determine how many of our students are later hired by our institution. I have a Sheet with a Student Name column , and would like to add a "Hired" Column in this sheet that would cross reference to a second sheet (Master employee list) and flag if there is a match in the Employee Name column (so if a…
-
Troubleshoot Workflows/notification not going to specific people (index/match formula driven)
Hello! I have a universal intake sheet to manage a variety of request. Assigned approvers are populated based on index/match formulas using a contact column. The notifications are working for everyone except one person. Oddly enough, when I push the notification as a test (and notify me), I don't get the notification…
-
How to update INDEX formula criteria in a specific way?
My company has created a freelancer invoicing system using two sheets. It depends on an INDEX formula that we now need to improve, which I'm having trouble doing. Sheet #1: A database with information on all individual freelancer (aka subcontractors) contracts (aka SOWs) Sheet #2: A form-based tracker with notifications…
-
Index / Match
Looking for some guidance. Goal: If "KPI Availability %" @ row is equal to or greater than "Annual Score % Availability" row 10 then it will look at the "Previous Contract Year Event" @ row and match it with the column header 0 , 2,3,4,5,6,7,8 (individual columns). Then it will look down the matched column where it matched…
-
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…
-
Listing cell contents from multiple cross reference fields in one cell (if statement, index/match?)
Hi, I am trying to do an if/index/match statement to pull the contents of a cross reference cell if it is not blank into a single cell. I need to be able to list several non-blank values with a paragraph break in between in a single cell and I am drawing a blank. Right now I have this: =IF({ParkingLotBlockedComm} <> "",…
-
Help with an INDEX(MATCH(MATCH( Formula
Hey all, I have two sheets: Business Consult and Project Proposal. I'd like to move specific info from that sheet onto the Project Proposal sheet using a unique identifier, the Business Consult ID. I've mirrored columns on both sheets and they are in the same order (though Project Proposal sheet has additional columns). My…
-
One of my criteria is one of many listed in a dropdown column and CONTAINS/HAS are eluding me.
Hello! I am working from a single "Master Sheet" and utilizing INDEX/COLLECT to pull the desired info onto separate sheets. I am utilizing "Feature", "Level" and "Product Line" as my criteria, however the "Product Line" is a multi-select dropdown column with anywhere from 1-10 values in it depending on the products usage.…
-
[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…