Match function response when no match found -


i have match function nested within if function. if match found within range, formula works. if match not found, "n/a": match not found. blank cell instead.

here link example spreadsheet illustrates question: https://docs.google.com/spreadsheets/d/1_yliqk_-7ygxakoigtfjlvwm3d-ia_rf1qo0_o_klwq/edit?usp=sharing

have tried match function returns? 0 no result or n/a?

you if returns 0 replace

if (match(..) >= 1, "1")  

with

if (match(..) >= 1, "1", "") 

otherwise should check result of match against logic function isna or isnumber

edit: apparently had be:

=iferror((then formula),"") 

Comments

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -