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)?

lookup with multiple rows returned
 

Paula,

Take a look at Data - Autofilter, or Data - Advanced filter

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"paula k" wrote in message
...
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)?