google sheet two criteria

[josvill2010]

Hi, I have this formula that works well to bring the data from EAST but I also would like to bring the data from WEST.
I want to avoid bringing North, South.
What do I need to do to the formula to get it working to include WEST and EAST?

This is the formula
=filter(importrange("Google Sheets: Sign-in", "Spend !A:U"),index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="EAST")

 

[Fluff]

Maybe

=filter(importrange("Google Sheets: Sign-in", "Spend !A:U"),(index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="EAST")+(index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="West"))

 

[josvill2010]

Maybe

=filter(importrange("Google Sheets: Sign-in", "Spend !A:U"),(index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="EAST")+(index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="West"))

it gives an error @ Formula parse error. It keeps adding two parenthesis after "West")"))
I tried with +(index) and +index. The only difference is an extra )))
+index(importrange(https:"...", "Spend!A:U"),0,1)="West")"))

 

[Fluff]

In that case you need to share your file, without that I cannot help any further.

 

[ogwt]

please share your sheet so this can be reviewed