If you want to check for a particular cell value in a column, then this is the formula you will have to use.
=IF(ISNA(MATCH(C3,F3:F96,0)),”T”,”F”)
Looking up a value for one cell in another array
03 Saturday Dec 2011
Posted in Uncategorized
03 Saturday Dec 2011
Posted in Uncategorized
If you want to check for a particular cell value in a column, then this is the formula you will have to use.
=IF(ISNA(MATCH(C3,F3:F96,0)),”T”,”F”)
