Index/Lookup formulae

Hi Team, Can you please share what sort of Index and match formuale would we write to bring in the Project ID on the New sheet
The project name on the auto updated is a combination and can be searched and then corresponding project id needs to be populated
Answers
-
=INDEX(COLLECT({Project ID Column Sheet 1}, {Project Name Column Sheet1}, CONTAINS([Project Name]@row, @cell)), 1)
-
Thank you. I should have named the columns differently. Just re-named them.
So based on your recommendation - =INDEX(COLLECT({Project ID Column Sheet 1}, {Project Name Column Sheet1}, CONTAINS([Project Name]@row, @cell)), 1)
the formulae would read as =INDEX(COLLECT({ID}, {Project}, CONTAINS([Shirt]), 1)
-
Almost. I believe this would be what you need based on your examples above:
=INDEX(COLLECT({ID}, {Project}, CONTAINS([Project Name]@row, @cell)), 1)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives