Forum Discussion
Excel Lookup That Skips Cells
Hi all, Been struggling with this problem that seems like it should be simple, but I suspect I don't know enough to figure out what combination of things would work. To summarise the setup (simp...
As variant
=LET(f, FILTER(Sheet2!C:C, (Sheet2!D:D=A1) ), IFERROR( @FILTER( f, f<>0 ), "no such") )