Comparing value of a cell to a range of cells
Closed
Hello,
I want to compare the value in a cell - B1 - to the values in a range of cells and return 1 if true and 0 if false. I set up $H$1:$H$14 as my range of values. Here is my formula
=IF(B1=$H$1:$H$14,1,0). Based on my results this is not comparing B1 with each cell H1 through H14. It is only comparing to the relative row- for example B2 is comparing to H2. What am I doing wrong?
I want to compare the value in a cell - B1 - to the values in a range of cells and return 1 if true and 0 if false. I set up $H$1:$H$14 as my range of values. Here is my formula
=IF(B1=$H$1:$H$14,1,0). Based on my results this is not comparing B1 with each cell H1 through H14. It is only comparing to the relative row- for example B2 is comparing to H2. What am I doing wrong?
Related:
- Comparing value of a cell to a range of cells
- Based on the cell values in cells b77 - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
1 response
Greetings,
Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.
Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse
To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!
You must copy, modify and repost your message respecting the politeness charter.
We trust that you understand.
Moderator
Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.
Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse
To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!
You must copy, modify and repost your message respecting the politeness charter.
We trust that you understand.
Moderator