View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
paula k paula k is offline
external usenet poster
 
Posts: 9
Default 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)?