In Excel, with a list in column A and C. If value in A2 exists in range C, assign value 1 in cell B2, else 0?

How can I do this? I would like to avoid script and just use a combination of Excel's built in functions.

In Excel, with a list in column A and C. If value in A2 exists in range C, assign value 1 in cell B2, else 0?
I recommend using match instead of vlookup as it does not require the lookup_array to be in any particular order when type is set to '0.'





for cell b2:


= if ( isna ( match ( A2 , C:C , 0 ) ) , 0 , offset ( $C$1 , match ( A2 , C:C , 0 ) -1 , 0 ) )





Syntax


MATCH ( search criterion , lookup_array , type )


ISNA ( value )


OFFSET ( reference , rows , columns , height , width )
Reply:The syntax is going to be as follows:





=IF(ISNA(VLOOKUP(A1, $C$1:$C$5, 1 ,FALSE)) ,0,1)





You will want to update the row values for the range of cells in the C column, but other than that, you should be able to paste this formula in to B1 and then copy and paste it to the other cells from there.