Forum Discussion
How can I apply the ISNUMBER function row-by-row until a value is found?
I can use the ISNUMBER formula explicitly to get the result I want. However, I need to do a dynamic row-by-row search until a value is returned and then stop. For example, I want to determine if the ...
=IFERROR(INDEX($S$1:$S$100, MATCH(TRUE, ISNUMBER(SEARCH(", "&A1&", ", ", "&$R$1:$R$100&", ")), 0)), "")
=IFERROR(INDEX($S$1:$S$100, MATCH(TRUE, ISNUMBER(SEARCH(", "&A1&", ", ", "&$R$1:$R$100&", ")), 0)), "")
- I understand maybe about half of that, but it WORKS!! That means it is magic. Thank you! That is a HUGE help.
