Most valuable professional
  • Hot Topics

Excel Converting Formula Yes No 0 1

. I am trying to combine the first formula with the one below. The It will read from the index a yes or no, and I want the yes or no to be converted to 0 and or 1. Thanks for any help! Code: =(INDEX(Sheet2!$AS$20:$AS$100,MATCH($BK20,Sheet2!$A$20:$A$100,0))) Code:

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of March 28, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel