I want to avoid spacing between rows when pulling data from another spreadsheet

[scsuflyboy]

Here is what I am trying to do. I have spreadsheet that I am trying to populate from another spreadsheet and I can't figure out how to avoid spacing when criteria isn't met:

Let me explain.

Spreadsheet Client View 2022:

Column A Column B Column C Column D etc.
Date Department location Contact Name

I have another spreadsheet, Dashboard - New View (Sheet 1)

Column A Column B Column C
=if(Sheet1(department="X",Sheet1(data in column c),"") etc.


I need the formula to evaluate each column in Client View and the first column that has department "x" the entire first available row in Dashboard - New View should populate with the data. The second row in Dashboard should continue evaluating each row in Client View and when it finds department "x" enter that info in the second column.

How do I accomplish this with a simple formula? Or does it require coding?

Thanks.

[dosydos]

sounds like FILTER() function could wokr. Honestly though had a hard time visualizing. Please upload a workbook with sample information. See yellow banner at top for instructions on how to do this:

[scsuflyboy]

I have attached 2 sample workbooks for reference. I did include a note in Dashboard - new view, to describe what I am looking to do.

[JeteMc]

If the REQUEST MGMT sheet is in a different workbook then cut the BSD_NMR_MANAGEMENT__2 table and paste it into another workbook, which should update the references in the formula.
The formula for the FACILITY column is:

Please Login or Register  to view this content.

Let us know if you have any questions.