Forum Discussion
Solved
How can I match two columns in a table to pull from a corresponding 3rd column?
I have a table of rows sorted by "project" where a Project can have multiple solution components represented in separate rows, each with a resource assigned. As in: For example: I need to fin...
Houston-Jack Replicated your table and used the new FILTER function to find the Resource based on the combination of Project and Solution. If your Excel version does not recognise it, a more traditional approach need to be taken.
Houston-Jack Replicated your table and used the new FILTER function to find the Resource based on the combination of Project and Solution. If your Excel version does not recognise it, a more traditional approach need to be taken.