If Contains Statement

Sarah Bystrom

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.

Paul Newcome

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))

Paul Newcome

Happy to help. 👍️

Bassam Khalil

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

Paul Newcome

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))

Sarah Bystrom

That worked perfectly! Thanks Paul!

Paul Newcome

Happy to help. 👍️