Incorrect Argument Set for MATCH, IF, AND formula
Hi there,
I feel like I'm close to a solution. I'm working in a symbol column that I would like to automate to turn either Gray or Green.
I would like to match a row across different sheets, if specific columns are blank on the other sheet for the match row, I'd like to return a gray symbol, if any one of them is not blank, I'd like to return a green symbol.
I've tried to nest an IF/AND statement into a MATCH operation. I'm getting 'incorrect argument set'.
=MATCH([NCT Number]@row, {NCT}, (IF(AND({Update Expected} = "", {Corrections Expected} = "", {Results Expected} = "", {All Results Expected} = ""), "Gray", "Green")), 0)
Is this figure-out-able?
Thank you!
Meredith
Meredith Rhodes, PhD
ClinicalTrials.gov Specialist
UW School of Medicine & Public Health
UW Clinical Trials Institute
mkrhodes@clinicaltrials.wisc.edu
Best Answer
-
Hi @Meredith Rhodes,
Give this a try.
=IF(COUNTIFS({NCT}, =[NCT Number]@row, {Update Expected}, ="", {Corrections Expected}, ="", {Results Expected}, ="", {All Results Expected}, ="") > 0, "Gray", "Green")
Hope that helps,
Dave
Answers
-
Hi @Meredith Rhodes,
Give this a try.
=IF(COUNTIFS({NCT}, =[NCT Number]@row, {Update Expected}, ="", {Corrections Expected}, ="", {Results Expected}, ="", {All Results Expected}, ="") > 0, "Gray", "Green")
Hope that helps,
Dave
-
Yes! Thank you @DKazatsky2! Success!
Meredith Rhodes, PhD
ClinicalTrials.gov Specialist
UW School of Medicine & Public Health
UW Clinical Trials Institute
mkrhodes@clinicaltrials.wisc.edu
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!