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...
SergeiBaklan
I'm afraid I can only half-follow what that formula is doing. Could you explain the logic?
Many thanks.
I'm afraid I can only half-follow what that formula is doing. Could you explain the logic?
Many thanks.
We filter from column C in Sheet2 all values for which value in column D is equal to A1. Result is filtered on all non-zero values. From these non-zero values we take first found by applying "@". Finally, if nothing was found, IFERROR gives a message.