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!


=(INDEX('Sheet2'!$AS$20:$AS$100,MATCH($BK20,'Sheet2'!$A$20:$A$100,0)))

=if(A1=0,"NO",if(a1=1,"YES","")) 


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