IF(AND(MATCH() Between Different Sheets Formula Assistance
I know I must be overthinking this…
I need a formula that basically states IF [IDCode] in {Sheet A} matches [IDCode] in {Sheet B}, AND [Response] in {Sheet B} is "Yes", then checkbox in {Sheet A} is checked, if false, then checkbox is unchecked.
I've tried every combination of IF(AND(INDEX(MATCH I could think of to make this work and I keep receiving #UNPARSABLE or #INCORRECT ARGUEMENT SET errors.
Thanks in advance!
Michael
Answers
-
You should be able to achieve this with a combination of
IF
,MATCH
, andINDEX
.- Ensure you have two sheets, Sheet A and Sheet B.
- In Sheet A, create a column for the checkbox.
- In Sheet A, use the following formula in the checkbox column:
=IF(AND(NOT(ISERROR(MATCH([IDCode]@row, {Sheet B IDCode}, 0))), INDEX({Sheet B Response}, MATCH([IDCode]@row, {Sheet B IDCode}, 0)) = "Yes"), 1, 0)
Make sure to replace
{Sheet B IDCode}
and{Sheet B Response}
with the actual references to the columns in Sheet B.This should solve your problem. If you encounter any issues, double-check that the column names are correctly referenced and the column types match the expected data types.
-
HECK YEAH!! Thank you, I didn't even think to use ISERROR and NOT functions!
I GREATLY appreciate your assistance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!