Index Match with "Starts with" match criteria
I'd like to pull in a value from a separate sheet if that value starts with "xyz" (for example) and also matches a specific project ID.
For example, if I have "xyz" as a value in one of the columns on spreadsheet 1. On spreadsheet 2, the value is called "xyz123." The two values have matching project IDs. How can I pull "xyz123" into a separate column on spreadsheet 1?
The value I'm trying to pull is also a child in a hierarchy. Does that factor into why I might be having difficulty?
I've tried to do this with LEFT and/or CONTAINS functions, but am not getting the result I need.
Help Article Resources
Check out the Formula Handbook template!