INDEX/COLLECT Formula Help
Hello All,
I am hoping this community can help me figure a particular scenario out:
I have 2 Sheets: Sheet A, Sheet B
I want to look at Sheet B:
Find a unique identifier in Column A (this is also the same unique identifier in Sheet A, Column A), then look at column C to see if it's blank.
If it's not blank, I want a checkbox to be checked in Column D in Sheet A.
I know that I need to use INDEX(COLLECT, but I can't seem to choose the correct range, criterion, range, etc.
Any help would be greatly appreciated!!
Answers
-
=IF(INDEX({Sht.A-Col.C}, MATCH(ID@row, {Sht.A-Col.A})) = "", 1, 0)
Sheet A -
Sheet B -
...
-
Hello heyjay,
Thank you for the quick response! It's close, but not quite what I am looking for:
I want the box to be checked if Sheet A Col. C is NOT blank. How would I incorporate that into your formula above?
-
Oh, replace
=
with<>
.Not Equals to Blank. You can also use
IF(NOT(ISBLANK…
=IF(INDEX({Sht.A-Col.C}, MATCH(ID@row, {Sht.A-Col.A})) <> "", 1, 0)
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!