INDEX MATCH W/ 2 criteria and partial match
If I enter "HII-1607302" on a separate sheet I want it to search the Project Number for that partial match and return the value in the Budgeted Multiplier Column into a cell. Two issues: The Project # (HII-1607302 for this example) is only a portion of the text in the Project column, so it needs to be a partial match not an exact match and 2nd issue - multiple rows will meet this first criteria - so I need it to only return the budgeted multiplier value that is greater than 0.
Help Article Resources
Check out the Formula Handbook template!