How can I combined these four separate vlookup formulas into one? (Google Sheets)

=NOT(ISERROR(VLOOKUP(B1,INDIRECT("OutboundCalls!B:B"),1,FALSE)))
=NOT(ISERROR(VLOOKUP(C1,INDIRECT("OutboundCalls!B:B"),1,FALSE)))
=NOT(ISERROR(VLOOKUP(D1,INDIRECT("OutboundCalls!B:B"),1,FALSE)))
=NOT(ISERROR(VLOOKUP(E1,INDIRECT("OutboundCalls!B:B"),1,FALSE)))

If you look at https://docs.google.com/a/advantagep...WKQ/edit#gid=0 I use these four formulas above on column O and get the desired results.

I tried combining them together as =NOT(ISERROR(VLOOKUP({B1;C1;D1;E1},INDIRECT("OutboundCalls!B:B"),1,FALSE))) and used it on Column N but it doesn't give me the right results.

I basically want Column N (using a single conditional format formula) to return the same results as Column O.

The reason I don't just use four separate conditional formats is because it's being used on a rather large and complex Google Sheet and I think the load is too intense for everything being done. I need to simplify it.

Thanks. You just need to add a INDIRECT() to reference sheets using Google Sheets. I think that's unique to reference sheets within conditional formatting only. I made that change to your formula and it seems to work now. Thanks for your help.

Here's the formula FYI

=sumproduct((INDIRECT("OutboundCalls!$B$2:$B$27")=B1:E1))>0