How to make a formula into an array

Question

I have the following formula in Google Sheets that I am trying to make into an array:

=TRANSPOSE(FILTER(AddressBook!A2:A,AddressBook!S2:S=A1))

Tried various different approaches but none have worked.

Any help greatly appreciated.

Answer 1

try perhaps like this:

=TRANSPOSE(ARRAYFORMULA(IFERROR(VLOOKUP(A1:A, 
 {AddressBook!S2:S, AddressBook!A2:A}, 2, 0))))