Can I populate a range from one sheet to another in one workbook based on if a cell is equal to something specific?

Question

I Have a workbook that I am using to track inventory and purchasing. The initial sheet contains the "List" which identifies if something is in inventory or if it needs purchasing, there is a data validation for "Inventory" or "Purchase" in Column E. I want to populate another sheet within the same workbook, only rows that end with the "Purchase" value in column E.

For example: In the sheet "List", if E2 is "Purchase", I want the sheet "Shopping" to populate with the values in List!A2:D2, I've tried a few combinations of If formulas and Arrayformula but haven't returned anything but Errors

I have tried in the shopping sheet, cell A2

=IF(List!E2"Purchase",List!A2:D2,blank)
=IF(List!E2"Purchase",Arrayformula(List!A2:d2),blank)

I've done a few other variations that I can't remember the exact order on but you get the gist of the ways I've tried it.

Answer 1

try:

=IF(List!E2="Purchase"; List!A2:D2; )

Answer 2

I would use the filter function

=filter(List!A2:E,List!E2:E = "Purchase")