Category: Microsoft Excel

Sample Formula:=IFERROR(IF(MATCH(C2,$A$2:$A$8,0), "1"), "0")Output:In above example, values in Column C is checked against Column A. If a value in Column C is found in Column A, 1 is displayed. Else, ....

1. Select Data Tab.2. Select the Columns.3. Click Sort.4. Select Sort By Column.

1. Go to View Tab.2. Select Freeze Panes and Freeze Top Row.

Sample formula:=NOT(ISERROR(MATCH(B49,$A$2:$A$254,0)))