Hi guys I am using Excel 2011. I am trying to make a formula that will return a 1 if certain numbers like 26, 52, 35 etc up to 20 different ones are found in Column Ac1 down to Ac500. If no numbers are found then it just says 0. I tried this formula but it does not do multiples IF(ISNA(VLOOKUP(26,$AC$5:$AC$15,0,FALSE)),"1","0") I am thinking now that this formula is not the way to go. thoughts?
This question generated 31 answers. To proceed to the answers, click here.
This thread is current as of November 29, 2013.