Is it possible to evaluate multiple predecessors and match to a cell value in another column?
I need to correlate a predecessor row to a work order number in a different column within the same sheet. There can be multiple predecessors. Is there a way to have a formula evaluate multiple predecessors and show a corresponding work order number?
Here is a screenshot, I'm trying to figure out if a formula can be used to populate the work order numbers (cell in yellow), based on the values in the predecessor column when there are multiple predecessors.
For each predecessor value, want to look up the work order number on the corresponding row.
Help Article Resources
Check out the Formula Handbook template!