.
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!
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:
=if(A1=0,"NO",if(a1=1,"YES",""))