If a range contains a specific value by column
|
Specific Value:
|
|
Range:
|
|
Value if range contains the specific value:
if the value that you want returned is a text value, you will need to include the quotation marks around the value. However, if you want to return a numeric value or referencing to a cell then there is no need to include the quotation marks. |
|
Value if range does not contain the specific value:
if the value that you want returned is a text value, you will need to include the quotation marks around the value. However, if you want to return a numeric value or referencing to a cell then there is no need to include the quotation marks. |
|
Formula:
|