Cross Sheet IF Statement
I'm struggling! I feel like this should be a simple formula but I'm unable to get it done. I'm referencing another sheet to bring in a name ONLY if their status in another column matches "Grandfathered".
In the formula below, I'm attempting to bring in the name of an individual (Range 5) if their status (Range 6) = "Grandfathered". In this example, the ranges are referring to columns within the referred to sheet. Please help!
*Disregard the first row. It's my attempt to make sure I'm not crazy and validate it works within the same sheet.
Answers
-
Hello @David Hancock - PSSI
You can use INDEX COLLECT function to get the name based on status
=INDEX(COLLECT({Reference Another Sheet - Name column}, {Reference Another Sheet - Status column}, "Grandfathered"),1)
Hope this helps.
Che
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!