Hello,
I am in need of a lookup for all rows associated with a project number. I know vLookup only finds the first value, which is not what I want. I need all values tied to a project
Can someone provide me with a formula or tell me which lookup formula to use? I am not a formula expert, so I am not sure what to google. I am using Excel 2016. Appreciate any help I can get. Thank you much!
Sample:
Project
PR556000
Output:
Project Number:
PR556000
PR556000
PR556000
PR556000
PR556000
I have attached a sample file.
Bookmarks