Formula for Column C:
Formula:
=IF(ISERROR(MATCH(A2,$F$2:$F$21,0)),B2,"")
Explanation:
- The MATCH function looks for the value in A2 within the range $F$2:$F$21. The "0" at the end means it's looking for an exact match.
- The ISERROR function checks if the MATCH function returns an error (i.e. if the value in A2 is not found in the range).
- If there is an error (i.e. the value is not found), then the formula returns the value in B2.
- If there is no error (i.e. the value is found), then the formula returns an empty string (which will display as a blank cell).
So essentially, the formula is saying "If the value in
A2 is not found in the range
$F$2:$F$21, then display the value in
B2. Otherwise, display nothing."
You can copy and paste this formula down the entire column to apply it to all rows. Let me know if you have any questions!