Pulling List of Rows from other sheet dependent on matching Cell Value? HELP See Pictures!

[apurcell]

Hello,
I have a workbook with Sheets 1 and 2 with data on them. This template is on Sheet 3. The template uses the cell D5 to pull data from these different sheets to populate. You type a project number (Proj#) in D5 and the rest should populate.

On "Sheet 1", I have a listing of all the different projects by Proj#. This sheet gives us the data for the Responsible Person, Exp Date, Department, Approved, Project title, and this data is populated using VLOOKUPS as there is only one result per project number. So for example, with project number 238, there is only one expiration date (6/30/2020). Got this working.

On "Sheet 2", I have a listing of Vendor Invoices, Description, PMT Date, % Comp, Proj#, and Amount. On this sheet, there can be more than one invoice per project number.

What I am trying to do: When I put a project number in cell D5 of my template on Sheet 3, I want to pull a list of all rows from columns J to P in "Sheet 2" with a matching project number in column O.

So if I put 302 in cell D5 in my Template, Rows 125, 126, & 128 Columns J-P from "Sheet 2" would fill in my template as follows:

 

[JLGWhiz]

You are using xl365 so you should be able to use the FILTER function.

=FILTER(Sheet2!A2:G19,Sheet2!F2:F19=D5)

I can't use that funtion on my old xl2013 version, but I believe the formula goes in the rop left cell of the range you want to populate. You can test it bebore applying it to see what it does. the syntax is
Filter(Range array of data,Range to Match=Criteria Range)

 

[apurcell]

Hell

You are using xl365 so you should be able to use the FILTER function.

=FILTER(Sheet2!A2:G19,Sheet2!F2:F19=D5)

I can't use that funtion on my old xl2013 version, but I believe the formula goes in the rop left cell of the range you want to populate. You can test it bebore applying it to see what it does. the syntax is
Filter(Range array of data,Range to Match=Criteria Range)

Hello,
Thank you for your response. It does not look like I have =FILTER() It just gives me =FILTERXML()

 

[JLGWhiz]

OK, you must have the earlier version of 365 then. If you do a web search for 'Filtrer Function Excel' and lodate the MS Support article, it gives the details. All of the versions starting with 2019 now have it. I use mostly vba so I don't really need it and have not bothered to upgrade to more recent version since I am retired and do not need to keep up for work purposes. Maybe if my system crashes again as it has in the past I will upgrade, but for now I just creep along with my old 2013 version.

Regards, JLG