What is wrong with this formula
Hi,
Im am trying to use this IF statement to check if the rows of 1 sheet have the same sections as the row on my current sheet and if it is true we return true. However, I cant seem to get this forumla to work. I was trying to add a @ row to the reference to the other sheet but it gives me an error. but if i just reference the column from the other sheet, it also gives me an error.
Answers
-
Hi. So the issue your if statement is comparing an entire Range to the section@row. Refrences wont work that way. Instead try using a count if statement. IF(COUNTIF({Refrence from other sheet}, = Section@row) >0,"True","False")
This will count every row you have that matches that particular range "Section@row" If it finds any rows that match it will flag it as true.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!