Select Where but Excel

[terraficke]

Hello Friends,

I would like to return values in one column based on certain conditions in a different column (but on a separate sheet).

Does anyone know the best way to do this? I basically want to create a new table from another table with filtered values but make it refreshable.

Help? I might be overthinking this.

<3

[#2 · Accepted solution]

@terraficke 

If you have Office 2021 or Microsoft 365, you can use the FILTER function 

[#3]

@Hans Vogelaar I have googled and googled this and somehow never came across this SIMPLE solution. Thank you!