lookup with multiple rows returned
Data:
A B C
D
Project 1 BC Mgmt Gov & Comp Falcone
Project 2 BC Mgmt Project Gov
Falcone
Project 3 Prog Mgmt BC Planning Johnson
Project 4 BC Mgmt 1-10 Plan
Falcone
Project 5 Prog Mgmt Metrics
Falcone
I would like to essentially filter all projects that "falcone" owns on
another tab. How would I lookup and return multiple values (details from col
a-c)?
|