I'm trying to return all result if the condition is empty, instead of #N/A, possible? Thank you
Sample sheet attached
https://docs.google.com/spreadsheets/d/1r8da7eOxEkx6JlAFQhU9zN055gGQfSyPAXVgpPEF2Ek
enter image description here
Thank You!
You may try:
=filter(A3:B9,if(I1="",B3:B9<>"",B3:B9=I1))