Most valuable professional
  • Hot Topics

Excel Formula for return a "1" if certain numbers are found

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.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel