Skip to main content
7 events
when toggle format what by license comment
Oct 12, 2022 at 20:07 comment added fini-stair thanks so much! this is super helpful.
Oct 12, 2022 at 17:36 comment added doubleunary The formula you quote needs to be copied down. You can make it work like this: =iferror( single( filter(Names!B$2:B, search(Names!A$2:A, A2)) ) ). The formula in the answer is an array formula that fills the whole column automatically, which makes spreadsheet management easier by avoiding one-off typos and the like.
Oct 12, 2022 at 16:19 comment added fini-stair I'm curious to know why you went for this approach when if we use the formula below which is at the core of your solution we seem to get the same result? "=iferror( single( filter(colors, search(names, searchKey)) ) ) :
Oct 12, 2022 at 16:17 vote accept fini-stair
Oct 12, 2022 at 14:33 vote accept fini-stair
Oct 12, 2022 at 16:17
Oct 12, 2022 at 14:33 comment added fini-stair Brilliant. Thank you so much. Really appreciate it!
Oct 12, 2022 at 13:56 history answered doubleunary CC BY-SA 4.0