Lookup Formula to output all values tied to one value

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.

Thank you sooo much oeldere for your assistance.

I failed to explain my issue correctly.

I have a report that I am looking up the value from. On the “Lookup Data” tab is the data I would like to pull the project data from. So when I enter a project number in the A2 row, the data will look up the values from the lookup tab and populate in the “Results” tab.

I am looking for a formula that functions like a vlookup, but instead of pulling in the first matching value, it will pull in all matching values

How about, in A6 dragged down & across
=IFERROR(INDEX('Lookup Data'!A$5:A$29,AGGREGATE(15,6,(ROW('Lookup Data'!$A$5:$A$29)-ROW('Lookup Data'!$A$5)+1)/('Lookup Data'!$A$5:$A$29=$A$2),ROWS(A$6:A6))),"")

Thank you Fluff13 for your response. I was able to use the updated file that oeldere provided.

Thank you oeldere! That is what I needed. I appreciate your time and help on my issue. :-)