Forum Discussion
Lookup until...
I have a lookup value in a cell on worksheet 2 and would like to lookup all the records on worksheet 1 that match with the lookup value. The values from 2 columns found on worksheet 1 should be liste...
A spill error? Try clearing the neighboring cells so FILTER may return the results.