If Contains Statement
I am trying to say If x column contains (a) value then display (b) value from another sheet. But it says Invalid Data Type
=IF({Retained Team Look Up Table Range 1}, CONTAINS(Resource@row, @cell), {Retained Team Look Up Table Range 2})
Retained Team Look Up Table Range 1 has the same values as in the Resource column of the grid I am in. If that matches I want it to display the value shown in the Retained Team Look Up Table Range 2.
Best Answers
-
You are actually going to need a VLOOKUP or the much more robust INDEX/MATCH.
=INDEX({Retained Team Look Up Table Range 2}, MATCH(Resource@row, {Retained Team Look Up Table Range 1}, 0))
-
Happy to help. 👍️
Answers
-
Hi @Sarah Bystrom
Hope you are fine,Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
Or if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.
My Email for sharing : Bassam.k@mobilproject.it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
You are actually going to need a VLOOKUP or the much more robust INDEX/MATCH.
=INDEX({Retained Team Look Up Table Range 2}, MATCH(Resource@row, {Retained Team Look Up Table Range 1}, 0))
-
That worked perfectly! Thanks Paul!
-
Happy to help. 👍️
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!