- 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:
- Microsoft Excel