Is there a way to use lookup to search within more than one range (i.e. "1:1" and "5:5") at the same time? I've tried declaring a named range containing both ranges but, while functions such as SUM() work just fine in such a split range, LOOKUP() returns an error.
I know I could use nested...