I'd like to lookup the activation type in C6 as well as the date range found in L6 and O6 on the "dashboard" tab and return the resulting rows (specifically columns E-J) from the "batches" tab?

Example Google Sheet

You can see in C17, I've been able to return a single value based on one lookup value, but would like to expand to lookup multiple values and return the entire row?

=IFERROR(LOOKUP(L$6,Batches!A:A,Batches!E:E),"no live activations for that date range")

1 Answer 1


It seems to me that FILTER would best suit your purpose. Try replacing your current C17 formula with this one:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.