How to check a value against a column in 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, 0 is displayed.

How to sort in Excel?

1. Select Data Tab.

2. Select the Columns.

3. Click Sort.

4. Select Sort By Column.

How to freeze Top Row in Excel?

1. Go to View Tab.

2. Select Freeze Panes and Freeze Top Row.